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
> 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