Re: timestamp out of range

From: "Calabaza Calabaza" <calalinux(at)gmail(dot)com>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: timestamp out of range
Date: 2007-09-19 14:21:07
Message-ID: 958993320709190721v7fb6bb0dreb7f997b3d36d488@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Te puedo mostrar la prueba que hice:
Ejecutando:

SELECT version()

SELECT current_setting('datestyle');

create table fechas (fecha varchar(10));

insert into fechas values('1984-06-14');
insert into fechas values('1983-02-21');
insert into fechas values('1989-06-13');

Select
fecha::timestamp without time zone
from fechas;

Estos fueron mis resultados:

"PostgreSQL 8.0.3 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)"

"ISO, MDY"

"1984-06-14 00:00:00"
"1983-02-21 00:00:00"
"1989-06-13 00:00:00"

No tengo un 8.2.4 a mano para probarlo, espero que te sirva.
--
§~^Calabaza^~§ from Villa Elisa, Paraguay

In response to

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Miguel Rodríguez Penabad 2007-09-19 14:31:46 Re: timestamp out of range
Previous Message Sebastián Villalba 2007-09-19 14:06:12 Re: PL/pgSQL