From: | dlibenzi(at)maticad(dot)it (Davide Libenzi) |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org> |
Subject: | datetime ?#!!??@ |
Date: | 1998-07-23 13:42:59 |
Message-ID: | 000701bdb63f$ce754a30$1f0104c0@pcdavide |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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(at)maticad(dot)it>
WWW: <http://www.maticad.it>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1998-07-23 14:15:30 | Re: [HACKERS] datetime ?#!!??@ |
Previous Message | Bruce Tong | 1998-07-23 12:59:06 | Re: [INTERFACES] ODBC Driver |
From | Date | Subject | |
---|---|---|---|
Next Message | D'Arcy J.M. Cain | 1998-07-23 13:58:19 | Re: [HACKERS] cidr |
Previous Message | Maarten Boekhold | 1998-07-23 09:01:55 | Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux] |