Thread: Default 'timestamp' value on HP-UX running Postgresql6.3.2

I am re-posting this query to the Interfaces and hackers mailing lists
with a little more information...

OS: HP_UX 10.2
Version of JDK : 1.1.5
Version of Postgres: 6.3.2
Date Style : ISO

I have a default record with a 'timestamp' field. Postgres saves 'epoch'
as the default value for this field but the JDBC driver/JDK on HP-UX 10.2
do not recognise this and I get a
'java.lang.StringIndexOutOfBoundsException' and
'java.sql.SQLException: Bad Date Format: at 0 in epoch'

Basically it is choking on 'epoch'.
- Is there a way to have the date returned in its numeric format
'1997-01-01.....' instead of epoch??
or
- Is there a patch for the JDBC driver with a fix for this?

I appreciate any help.
Thank You

-SR

---------------------- Forwarded by Sangeeta Rao/MW/US/3Com on 10/05/98
11:52 AM ---------------------------

Sangeeta Rao/MW/US/3Com
09/29/98 04:58 PM


To:   pgsql-general@hub.org@3COM-MWGATE
cc:
Subject:  Default 'timestamp' value on HP-UX running Postgresql6.3.2

I am running postgres 6.3.2 on HP_UX 10.2. I have a field defined as
type 'timestamp' and am using ISO datestyle. The default value shows
up as the string constant 'epoch'. Is there any way of having the numeric
value of '1970-01-01 00:00:00+00'  returned instead??

I appreciate any help! Thanks.
-sr