Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-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

$ psqk mydb

mydb==> create table foo (ffoo datetime);

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

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: <>

pgsql-hackers by date

Next:From: D'Arcy J.M. CainDate: 1998-07-23 13:58:19
Subject: Re: [HACKERS] cidr
Previous:From: Maarten BoekholdDate: 1998-07-23 09:01:55
Subject: Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

pgsql-general by date

Next:From: Tom LaneDate: 1998-07-23 14:15:30
Subject: Re: [HACKERS] datetime ?#!!??@
Previous:From: Bruce TongDate: 1998-07-23 12:59:06
Subject: Re: [INTERFACES] ODBC Driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group