datetime ?#!!??@

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>

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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]