Skip site navigation (1) Skip section navigation (2)

Re: Timestamp trouble

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 (view raw or flat)
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) 



In response to

pgsql-novice by date

Next:From: Van Ingen, LaneDate: 2005-06-08 20:15:53
Subject: SubQuery Question
Previous:From: Daniel T. StaalDate: 2005-06-08 16:59:48
Subject: Re: Timestamp trouble

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group