datetime ?#!!??@ - Mailing list pgsql-general

From dlibenzi@maticad.it (Davide Libenzi)
Subject datetime ?#!!??@
Date
Msg-id 000701bdb63f$ce754a30$1f0104c0@pcdavide
Whole thread Raw
Responses Re: [HACKERS] datetime ?#!!??@  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I've successfully ported PostgreSQL to HPUX 9.0.* but there is a strange
behaviour with the datetime data type.

If do do this sequence :

$ createdb mydb
[OK]

$ psqk mydb

mydb==> create table foo (ffoo datetime);
[OK]

mydb==> insert into foo values ('01/01/1998');
[OK]

mydb==> select ffoo from foo;

The rusult is a totally wrong date with year 2140.

I've tried to set datestyle but the results don't change.

Has anybody a hint for me ?

----
Davide Libenzi at :
Maticad s.r.l.
Via Della Giustizia n.9 Fano (PS) 61032 Italy
Tel.: +39-721-808308 (ra)  Fax: +39-721-808309
Email: <davidel@maticad.it>
WWW: <http://www.maticad.it>



pgsql-general by date:

Previous
From: Postgres
Date:
Subject: ...
Next
From: Bruce Tong
Date:
Subject: Re: [INTERFACES] ODBC Driver