On Wed, Feb 05, 2003 at 11:22:57PM -0500, Tom Lane wrote:
> Rodger Donaldson <[EMAIL PROTECTED]> writes:
> > values (to_date('06/Feb/2003:11:29:11 +13', 'DD/Mon/YYYY:HH24:MI:SS'),0,302,
>
> > Always inserts the correct date, but sets the time to midnight.
>
> Um, well, yeah ... it's to_DATE, meaning it produces a result of type
> date. I think you wanted to_timestamp().
Why yes. Yes I did. Too much time spent with Oracle, evidently.
Next I'll be wondering why DECODE doesn't work...
--
Rodger Donaldson [EMAIL PROTECTED]
"How do I set my laser printer for stun?"
-- William Tansil
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
