With CVS tip (and float-type timestamps) I get

regression=# select date('2002-02-01 00:00:00'::timestamp);
    date
------------
 2000-01-01
(1 row)

Seems to be the same result no matter what timestamp is put in.

			regards, tom lane

Mon, 20 May 2002 11:25:31 -0400
Tom Lane <tgl@sss.pgh.pa.us>
timestamp-to-date broken in current sources
> With CVS tip (and float-type timestamps) I get
...
> Seems to be the same result no matter what timestamp is put in.

Yup. Broken for double timestamps. Will patch...

                 - Thomas

Mon, 20 May 2002 09:16:44 -0700
Thomas Lockhart <thomas@fourpalms.org>
Re: timestamp-to-date broken in current sources