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