to_timestamp and to_date fails in postgresql 7.1.3

Started by kaab kaoutarover 22 years ago2 messagesgeneral
Jump to latest
#1kaab kaoutar
kaab_k@hotmail.com

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

#2Alvaro Herrera
alvherre@dcc.uchile.cl
In reply to: kaab kaoutar (#1)
Re: to_timestamp and to_date fails in postgresql 7.1.3

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)