Re: DateTime fields

Here is am example of what I am doing.....

danderso=# \d test
Table "test"
Attribute | Type | Modifier
-----------+-----------+----------
time | timestamp |

danderso=# insert into test values (to_timestamp('1200 PM JUN 27 2000','HHMI PM MON DD YYYY'));
INSERT 22825 1
danderso=# select * from test;
time
------------------------
2000-06-28 00:00:00-05
(1 row)

danderso=#

Thanks,
Dale.

>>> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 06/26/00 05:41PM >>>
"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