Re: TO_DATE and single digit months driving me nuts...

Karel Zak wrote:
>
> On Tue, 23 May 2000, Philip Hallstrom wrote:
>
> > 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')
>
> If I good understand you:
>
> test=# select TO_TIMESTAMP('2000 5 25 09 30', 'YYYY FMMM DD HH24 MI');
> to_timestamp
> ------------------------
> 2000-05-25 09:30:00+02
>
> The 'FM' (fill-mode) is a local option and is always used for next element.
> In your example for 'MM'. Without 'FM' formatter expect full number.
>
> Karel

Wow! That is nice. That's one damned good implementation of the
ORACLE TO_xxx routines. :-)

MIke Mascari