From: | Mike Mascari <mascarm(at)mascari(dot)com> |
---|---|
To: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
Cc: | Philip Hallstrom <philip(at)adhesivemedia(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: TO_DATE and single digit months driving me nuts... |
Date: | 2000-05-24 12:08:12 |
Message-ID: | 392BC62C.41B4688B@mascari.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Karl DeBisschop | 2000-05-24 12:38:41 | Re: plperl extensions |
Previous Message | Karel Zak | 2000-05-24 12:05:13 | Re: TO_DATE and single digit months driving me nuts... |