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