*/
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