*/
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('
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
'));
INSERT 22825 1
dand
On Mon, 26 Jun 2000, Tom Lane wrote:
> "Dale Anderson" <[EMAIL PROTECTED]> 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?
>
> Looks fine to me.
No, you overlook "to_timestamp()" in query. This routine
