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

From: "Sangeeta Rao" <Sangeeta_Rao(at)mw(dot)3com(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Default 'timestamp' value on HP-UX running Postgresql6.3.2
Date: 1998-10-05 17:03:41
Message-ID: 86256694.005C568D.00@mwgate02.mw.3com.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-interfaces


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(at)hub(dot)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

Browse pgsql-general by date

  From Date Subject
Next Message Melanie Renee Nelson 1998-10-05 17:19:16 dropping a column from a table
Previous Message Doug Younger 1998-10-05 16:13:51 Binary number data type?

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas G. Lockhart 1998-10-05 17:15:38 Re: [HACKERS] vacuum analyze problem
Previous Message Thomas G. Lockhart 1998-10-05 14:44:01 Re: man-page install (was Re: pg_dump new -n flag)

Browse pgsql-interfaces by date

  From Date Subject
Next Message Thomas G. Lockhart 1998-10-05 17:07:31 Re: [INTERFACES] Re: Just some unfinished stuff.
Previous Message Gerald Gryschuk 1998-10-05 15:31:17 I think I got it.