Is this a bug?
bleah=> select ('Mon Nov 29 21:47:04 PST 1999'::timestamp);
?column?
----------------------
1999-11-30 00:47:04-05
(1 row)
bleah=> select ('Mon Nov 29 21:47:04 PST 1999'::timestamp)::date;
?column?
----------
11-29-1999
(1 row)
bleah=>