Re: Error: Bad Timestamp Format - Mailing list pgsql-general

From Thomas Lockhart
Subject Re: Error: Bad Timestamp Format
Date
Msg-id 3BA039FD.914F17B0@fourpalms.org
Whole thread Raw
In response to Error: Bad Timestamp Format  (Graham Leggett <minfrin@sharp.fm>)
List pgsql-general
Martijn van Oosterhout wrote:
>
> On Wed, Sep 12, 2001 at 04:55:35PM +0000, Thomas Lockhart wrote:
> > NOTICE:  DateStyle is ISO with US (NonEuropean) conventions
> That's yyyy-dd-mm

Ah. No, that is not yyyy-dd-mm. It is yyyy-mm-dd (per ISO spec) for
output, and there are a wide range of various formats accepted for
input. The "US" vs "European" conventions come into play *only* when
trying to decipher ambiguous inputs which are *not* in ISO format.

The docs have a description of this, though suggestions (or patches) for
clarification are welcome.

hth

                        - Thomas

pgsql-general by date:

Previous
From: lbayuk@mindspring.com (ljb)
Date:
Subject: Re: pg_dump problem
Next
From: Eric Kolve
Date:
Subject: postgresql reference application