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

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 (view raw or flat)
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: Checkpoint.java
Description: text/plain (3.7 KB)

pgsql-bugs by date

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

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