Re: to_date has beaten me...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rodgerd(at)diaspora(dot)gen(dot)nz
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: to_date has beaten me...
Date: 2003-02-06 04:22:57
Message-ID: 9133.1044505377@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Rodger Donaldson <rodgerd(at)diaspora(dot)gen(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rodger Donaldson 2003-02-06 04:25:39 Re: to_date has beaten me...
Previous Message Rodger Donaldson 2003-02-06 04:02:48 to_date has beaten me...