From: | Razvan Costea-Barlutiu <cbrazvan(at)laitek(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Timestamp trouble |
Date: | 2005-06-08 17:02:21 |
Message-ID: | 6.1.2.0.0.20050608195818.01a85ec0@mail.laitek.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thank you Bruno. Indeed, adding the space there did the trick, thanks a bunch for the lead.
However, is there any way to do this without interfering with the original timestamp string?
Thank you,
Razvan
>> 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?
>
>This seems to work:
>
>area=> select '19990108 040506'::timestamp;
> timestamp
>---------------------
> 1999-01-08 04:05:06
>(1 row)
From | Date | Subject | |
---|---|---|---|
Next Message | Van Ingen, Lane | 2005-06-08 20:15:53 | SubQuery Question |
Previous Message | Daniel T. Staal | 2005-06-08 16:59:48 | Re: Timestamp trouble |