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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Reply via email to