Problem storing dates with JDBC

From: John Summerfield <summer(at)OS2(dot)ami(dot)com(dot)au>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Problem storing dates with JDBC
Date: 1999-03-01 05:02:35
Message-ID: Pine.LNX.4.02.9903011233450.16459-200000@emu.os2.ami.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Your name :John Summerfield
Your email address :summer(at)os2(dot)ami(dot)com(dot)au

System Configuration
---------------------
Architecture (example: Intel Pentium) :Intel Pentium

Operating System (example: Linux 2.0.26 ELF) : 2.2.2 (client), 2.0.35
(server)

PostgreSQL version (example: PostgreSQL-6.3.2) : PostgreSQL-6.3.2

Compiler used (example: gcc 2.7.2) :gcc 2.7.2

java full version "Linux_JDK_1.1.7_v1a_green_threads

I trust this is enough to identify the version of jdbc:
[summer(at)possum data]$ jar -tv /usr/share/postgresql/postgresql.jar

[summer(at)possum data]$ jar -tvf /usr/share/postgresql/postgresql.jar
3502 Sun Aug 02 15:25:58 GMT 1998 META-INF/MANIFEST.MF
3430 Sun Aug 02 15:25:44 GMT 1998 postgresql/fastpath/Fastpath.class
1019 Sun Aug 02 15:25:46 GMT 1998 postgresql/fastpath/FastpathArg.class
1830 Stun Aug 02 15:25:48 GMT 1998 postgresql/geometric/PGbox.class
2159 Sun Aug 02 15:25:50 GMT 1998 postgresql/geometric/PGpoint.class
2064 Sun Aug 02 15:25:50 GMT 1998 postgresql/geometric/PGcircle.class
1864 Sun Aug 02 15:25:52 GMT 1998 postgresql/geometric/PGlseg.class
2289 Sun Aug 02 15:25:54 GMT 1998 postgresql/geometric/PGpath.class
1703 Sun Aug 02 15:25:56 GMT 1998 postgresql/geometric/PGpolygon.class
2355 Sun Aug 02 15:25:42 GMT 1998 postgresql/largeobject/LargeObjectManager.class
2458 Sun Aug 02 15:25:42 GMT 1998 postgresql/largeobject/LargeObject.class
998 Sun Aug 02 15:25:42 GMT 1998 postgresql/util/PGobject.class
23314 Sun Aug 02 15:25:46 GMT 1998 postgresql/util/UnixCrypt.class
2033 Sun Aug 02 15:25:50 GMT 1998 postgresql/util/PGtokenizer.class
1663 Sun Aug 02 15:25:36 GMT 1998 postgresql/CallableStatement.class
6540 Sun Aug 02 15:25:38 GMT 1998 postgresql/PreparedStatement.class
2784 Sun Aug 02 15:25:38 GMT 1998 postgresql/Statement.class
11121 Sun Aug 02 15:25:42 GMT 1998 postgresql/Connection.class
9496 Sun Aug 02 15:25:44 GMT 1998 postgresql/ResultSet.class
3675 Sun Aug 02 15:25:44 GMT 1998 postgresql/PG_Stream.class
3684 Sun Aug 02 15:25:44 GMT 1998 postgresql/Driver.class
20716 Sun Aug 02 15:25:46 GMT 1998 postgresql/DatabaseMetaData.class
2967 Sun Aug 02 15:25:46 GMT 1998 postgresql/Field.class
3164 Sun Aug 02 15:25:48 GMT 1998 postgresql/ResultSetMetaData.class
[summer(at)possum data]$

Please enter a FULL description of your problem:
------------------------------------------------
Dates, when retrieved, are advanced by one day from what was supposed to be
stored:

[summer(at)possum data]$ date;jikes -g Checkpoint.java -d ~/Classes && jre mystocks.data.Checkpoint;echo select \* from tjs0103_checkpoints\; | psql sharetrader -h emu
Mon Mar 1 12:51:11 WST 1999
Mon Mar 01 04:51:12 GMT 1999
java.util.GregorianCalendar[time=920263872553,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=java.util.SimpleTimeZone[id=GMT,offset=0,dstSavings=3600000,useDaylight=false,startYear=0,startMode=0,startMonth=0,startDay=0,startDayOfWeek=0,startTime=0,endMode=0,endMonth=0,endDay=0,endDayOfWeek=0,endTime=0],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=1999,MONTH=2,WEEK_OF_YEAR=10,WEEK_OF_MONTH=1,DAY_OF_MONTH=1,DAY_OF_YEAR=60,DAY_OF_WEEK=2,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR=4,HOUR_OF_DAY=4,MINUTE=51,SECOND=12,MILLISECOND=553,ZONE_OFFSET=0,DST_OFFSET=0]
1999
1
1999-03-01
select * from tjs0103_checkpoints;
when|program |programdata
----------+----------+-----------
03-02-1999|Checkpoint|
(1 row)

EOF
[summer(at)possum data]$

Source code is attached.

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
Customise the attached java program as needed & run it.

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

--
Cheers
John Summerfield
http://os2.ami.com.au/os2/ for OS/2 support.
Configuration, networking, combined IBM ftpsites index.

Attachment Content-Type Size
Checkpoint.java text/plain 3.7 KB

Browse pgsql-bugs by date

  From Date Subject
Next Message Giuseppe Tanzilli 1999-03-01 15:28:08 Bug report
Previous Message Unprivileged user 1999-02-27 23:03:17 General Bug Report: pg_dump produces erroneous output