Hi -
I'm playing around with inserting dates into a timestamp field and
am getting annoyed at single digit dates/days/hours/minutes.
The problem is that I have something like:
TO_TIMESTAMP('2000 5 25 09 30', 'YYYY MM DD HH24 MI')
which fails because it expects the month to be "05" instead of "5". Other
than pad all these myself in my code, is there some way to tell the
formatter to allow for missing leading zeros? Something similar to the
"fm" format option, but a bit different...
Thanks!
-philip