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