| From: | Razvan Costea-Barlutiu <cbrazvan(at)laitek(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Timestamp trouble |
| Date: | 2005-06-08 16:27:25 |
| Message-ID: | 6.1.2.0.0.20050608192307.01cf3ec0@mail.laitek.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hello all,
I am getting hit by errors in timestamp formatting on seemingly valid timestamps:
19990108040506.
From the PG manual:
<Valid input for the time stamp types consists of a concatenation of a date and a time, followed by an optional time zone, followed by an optional AD or BC. (Alternatively, AD/BC can appear before the time zone, but this is not the preferred ordering.)>
The string above is the concatenation of two ISO 8601 date+time fields but still, the error is thrown each time.
Is this a bug or is it a workaround for this?
The system I use:
WinXP, SP2
PG 8.0.1.
Thank you and best regards,
Razvan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2005-06-08 16:54:31 | Re: Timestamp trouble |
| Previous Message | Todd Lewis | 2005-06-08 14:11:25 | Re: CRON Jobs and Backups |