Postgres Pro
Downloads
Home   >   mailing lists

Re: DateTime fields - Mailing list pgsql-general

From Karel Zak
Subject Re: DateTime fields
Date
Msg-id Pine.LNX.3.96.1000627094243.5765A-100000@ara.zf.jcu.cz
Whole thread Raw
In response to Re: DateTime fields  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: DateTime fields  (Ted Nolan SRI Augusta GA <ted@ags.ga.erg.sri.com>)
List pgsql-general
Tree view 
On Mon, 26 Jun 2000, Tom Lane wrote:

> "Dale Anderson" <danderso@crystalsugar.com> 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 really has bug in
PM/AM interpretation.

                    Karel

pgsql-general by date:

Previous
From: NRonayette
Date:
Subject: Re: Why isn't that null
Next
From: Tom Lane
Date:
Subject: Re: Conversion from MS Access to Postgresql