Invalid date in database

From: Robert(dot)Farrugia(at)go(dot)com(dot)mt
To: pgsql-admin(at)postgresql(dot)org
Subject: Invalid date in database
Date: 2001-10-12 08:59:30
Message-ID: OFFA8885F7.3D04CE99-ONC1256AE3.0030EFC7@go.com.mt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I noticed the following thing in postgres (7.1.x). I have a timestamp
field which is populated by a java program using the new
java.sql.Timestamp(System.currentTimeMillis()) command so as to set the
current time when the record was edited (I know that I can use the now()
command, but this is just an example). For most of the records, the
timestamp is correct. But some of the records have incorrect timestamps
namely they have a second value of 60 (e.g. 2001/10/12 12:14:60.00).

This is creating problems especially when dumping/restoring as pg_dump
dumps them incorrectly (2001/10/12 12:14:60.00) and then psql refuses to
load them up.

Any comments on this ?

Regards
Robert

Browse pgsql-admin by date

  From Date Subject
Next Message Stefan Huber 2001-10-12 11:56:14 Re: Permission Denied When i am Trying to take Backup
Previous Message Rolf Lüttecke 2001-10-12 07:46:10 Intel C++ Compiler