Thread: to_timestamp and to_date fails in postgresql 7.1.3

to_timestamp and to_date fails in postgresql 7.1.3

From
"kaab kaoutar"
Date:
Hi,

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?

Thx

_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail


Re: to_timestamp and to_date fails in postgresql 7.1.3

From
Alvaro Herrera Munoz
Date:
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[@]dcc.uchile.cl>)
"Crear es tan dificil como ser libre" (Elsa Triolet)