Обсуждение: to_timestamp and to_date fails in postgresql 7.1.3

Поиск
Список
Период
Сортировка

to_timestamp and to_date fails in postgresql 7.1.3

От
"kaab kaoutar"
Дата:
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

От
Alvaro Herrera Munoz
Дата:
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)