From: Sangeeta Rao <Sangeeta_Rao@mw.3com.com>
To: pgsql-interfaces@postgresql.org
To: pgsql-hackers@postgresql.org
To: pgsql-general@postgresql.org
Subject: Default 'timestamp' value on HP-UX running Postgresql6.3.2
Date: Mon, 5 Oct 1998 12:03:41 -0500
Message-ID: <86256694.005C568D.00@mwgate02.mw.3com.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: Sangeeta_Rao@mw.3com.com, pgsql-hackers@postgresql.org, pgsql-general@postgresql.org
Subject: Re: Default 'timestamp' value on HP-UX running Postgresql6.3.2
In-Reply-To: <86256694.005C568D.00@mwgate02.mw.3com.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox