Timestamp trouble - Mailing list pgsql-novice

From Razvan Costea-Barlutiu
Subject Timestamp trouble
Date
Msg-id 6.1.2.0.0.20050608192307.01cf3ec0@mail.laitek.com
Whole thread Raw
Responses Re: Timestamp trouble
Re: Timestamp trouble
List 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
preferredordering.)> 

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



pgsql-novice by date:

Previous
From: Frank Bax
Date:
Subject: Re: CRON Jobs and Backups
Next
From: Bruno Wolff III
Date:
Subject: Re: Timestamp trouble