Re: Convert TimeStamp to Date - Mailing list pgsql-general

On Wed, Jul 23, 2003 at 01:36:52PM -0400, shuai@objectwareinc.com wrote:
> Hi all,
>
> I am trying to convert a timestamp field to a date. ('1993-08-10
> 17:48:41.074' to '1993-08-10').
> I used date(TIMESTAMP_FIELD), but it seemed working only for date
> after year 2000 and return the previous date
> for any day before year 2000. Is that a bug or I just didn't
> understand the function?

tree=# select date('1993-08-10 17:48:41.074');
    date
------------
 10-08-1993
(1 row)

Maybe I don't understand what you mean: that was a date before 2000, and
it seems to give the right answer..

I tend to be pedantic and use
  select cast('1993-08-10 17:48:41.074' as date)

Cheers,

Patrick