Re: DateTime fields

*/

On Tue, 27 Jun 2000, Dale Anderson wrote:

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

And for me:

test=# select to_timestamp('1200 PM JUN 27 2000', 'HHMI PM MON DD YYYY');
to_timestamp
------------------------
2000-06-27 12:00:00+02

but don't worry, you are right, I have NEW FIXED version. I commit it
tomorrow.

(Tom wanted show you that standard date/time routines are right only.)

Karel