Postgres Pro
Downloads
Home   >   mailing lists

Re: to_date has beaten me... - Mailing list pgsql-sql

From Tom Lane
Subject Re: to_date has beaten me...
Date
Msg-id 9133.1044505377@sss.pgh.pa.us
Whole thread Raw
In response to to_date has beaten me...  (Rodger Donaldson <rodgerd@diaspora.gen.nz>)
Responses Re: to_date has beaten me...  (Rodger Donaldson <rodgerd@diaspora.gen.nz>)
List pgsql-sql
Tree view 
Rodger Donaldson <rodgerd@diaspora.gen.nz> 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().
        regards, tom lane

pgsql-sql by date:

Previous
From: Rodger Donaldson
Date:
Subject: to_date has beaten me...
Next
From: Rodger Donaldson
Date:
Subject: Re: to_date has beaten me...