Re: DateTime fields - Mailing list pgsql-general

From Thomas Lockhart
Subject Re: DateTime fields
Date
Msg-id 395809D4.D71C71CE@alumni.caltech.edu
Whole thread Raw
In response to DateTime fields  ("Dale Anderson" <danderso@crystalsugar.com>)
List pgsql-general
> > I noticed that the DateTime fields and
> > the to_timestamp function interpret
> > 12 PM as 00:00 and 12 AM as 12:00.
> Looks fine to me.

I'm seeing a bit of weirdness on my desktop Postgres-7.0.3 Mandrake
Linux installation, where am/pm results in a 60 second offset added to
the seconds field in the output (but also getting the 00:00/12:00 part
correct).

Same on my laptop, which has a 7.0.0 installation.

But my from-cvs installation of the current sources on the same laptop,
things look good.

I don't know why there would be a difference; afaik this code wasn't
touched recently.

                     - Thomas

pgsql-general by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Conversion from MS Access to Postgresql
Next
From: Thomas Lockhart
Date:
Subject: Re: Inserting all defaults