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@sss.pgh.pa.us> 06/26/00 05:41PM >>>
"Dale Anderson" <danderso@crystalsugar.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