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

Re: Timestamp trouble

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Razvan Costea-Barlutiu <cbrazvan(at)laitek(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Timestamp trouble
Date: 2005-06-08 16:54:31
Message-ID: 20050608165431.GA2053@wolff.to (view raw or flat)
Thread:
Lists: pgsql-novice
On Wed, Jun 08, 2005 at 19:27:25 +0300,
  Razvan Costea-Barlutiu <cbrazvan(at)laitek(dot)com> wrote:
> 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

Responses

pgsql-novice by date

Next:From: Daniel T. StaalDate: 2005-06-08 16:59:48
Subject: Re: Timestamp trouble
Previous:From: Razvan Costea-BarlutiuDate: 2005-06-08 16:27:25
Subject: Timestamp trouble

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