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

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-hackerspgsql-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??
- Is there a patch for the JDBC driver with a fix for this?

I appreciate any help.
Thank You


---------------------- 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
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.

pgsql-hackers by date

Next:From: Michael MeskesDate: 1998-10-05 17:04:39
Subject: Re: [HACKERS] need help with csh
Previous:From: Thomas G. LockhartDate: 1998-10-05 14:44:01
Subject: Re: man-page install (was Re: pg_dump new -n flag)

pgsql-interfaces by date

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

pgsql-general by date

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

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