Re: DateTime fields

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Dale Anderson <danderso(at)crystalsugar(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: DateTime fields
Date: 2000-06-27 07:45:52
Message-ID: Pine.LNX.3.96.1000627094243.5765A-100000@ara.zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Mon, 26 Jun 2000, Tom Lane wrote:

> "Dale Anderson" <danderso(at)crystalsugar(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-06-27 08:32:08 Re: Conversion from MS Access to Postgresql
Previous Message Mitch Vincent 2000-06-27 07:25:45 Plan question..