Re: DateTime fields - Mailing list pgsql-general

From Karel Zak
Subject Re: DateTime fields
Date
Msg-id Pine.LNX.3.96.1000627152117.20762D-100000@ara.zf.jcu.cz
Whole thread Raw
In response to Re: DateTime fields  ("Dale Anderson" <danderso@crystalsugar.com>)
List pgsql-general
 */

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


pgsql-general by date:

Previous
From: Louis-David Mitterrand
Date:
Subject: BLOB DBI func() interface under postgres
Next
From: "Poul L. Christiansen"
Date:
Subject: Re: How to dump from Postgre