"Dale Anderson" <danderso(at)crystalsugar(dot)com> writes:
> I noticed that the DateTime fields and the to_timestamp function
> interpret 12 PM as 00:00 and 12 AM as 12:00.
Huh?
regression=# select '2000-06-12 12:00 am' ::datetime;
?column?
------------------------
2000-06-12 00:00:00-04
(1 row)
regression=# select '2000-06-12 12:00 pm' ::datetime;
?column?
------------------------
2000-06-12 12:00:00-04
(1 row)
Looks fine to me.
Could you be more precise about what you're trying to do?
regards, tom lane