| From: | Thomas Lockhart <lockhart(at)fourpalms(dot)org> |
|---|---|
| To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| Cc: | Graham Leggett <minfrin(at)sharp(dot)fm>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Error: Bad Timestamp Format |
| Date: | 2001-09-13 04:45:49 |
| Message-ID: | 3BA039FD.914F17B0@fourpalms.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian MEUNIER | 2001-09-13 04:53:37 | Re: Questions about tuning on FreeBSD... |
| Previous Message | Sapenov | 2001-09-13 03:23:42 | Can I insert two different variables from form into different tables using one SQL query ? |