Re: to_timestamp and to_date fails in postgresql 7.1.3

From: Alvaro Herrera Munoz <alvherre(at)dcc(dot)uchile(dot)cl>
To: kaab kaoutar <kaab_k(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: to_timestamp and to_date fails in postgresql 7.1.3
Date: 2003-09-09 21:20:26
Message-ID: 20030909212026.GB25039@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Sep 09, 2003 at 06:36:48PM +0000, kaab kaoutar wrote:

> A client is using postgresql 7.1.3, and to_date() and to_timestamp()
> functions fail sometimes,However they never do in postgresql 7.3.2.
> Are these bugs?

Maybe you are getting some interval with the seconds field set to 60?
It was possible in 7.1.3 for sure. You get it from the database (I get 'em
sometimes when I try to select a random interval in 7.1.3) and then it
won't accept it back.

--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"Crear es tan dificil como ser libre" (Elsa Triolet)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2003-09-09 21:38:50 Re: Find overlapping time intervals, how?
Previous Message scott.marlowe 2003-09-09 21:07:03 Re: Picture with Postgres and Delphi