Re: [GENERAL] datetime ?#!!??@
От | dlibenzi@maticad.it (Davide Libenzi) |
---|---|
Тема | Re: [GENERAL] datetime ?#!!??@ |
Дата | |
Msg-id | 000601bdb662$c221d7d0$1f0104c0@pcdavide обсуждение исходный текст |
Список | pgsql-general |
Pathc PHSS_4630 applied ! Everything OK ---- 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> -----Original Message----- From: Davide Libenzi <dlibenzi@maticad.it> To: pgsql-hackers@postgreSQL.org <pgsql-hackers@postgreSQL.org>; pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org> Date: Thursday, July 23, 1998 1:55 PM Subject: [GENERAL] datetime ?#!!??@ >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 по дате отправления: