pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: christopher baus <christopher@baus.net>
To: pgsql-interfaces@hub.org
Subject: date format question.
Date: Sun, 21 May 2000 14:54:53 -0700
Message-ID: <09b801bfc36f$32b0d8a0$9500a8c0@styleadvisor.com> (raw)
References: <200005210739.DAA56258@hub.org>

Hi all,

I just started using postgreSQL 7.0 and the JDBC 1.1 driver with apache's
turbine project.  I am a bit confused by your date handling.  Turbine uses
timestamp fields to stamp user login/logout.  The driver allows me to set
the login in the following format : 2000-05-21 02:04:12.33-04

When I requery the field the driver throws an invalid date format exception.
I would like to be able to be assured that a java date will be transformed
to the proper format.  I'm not an expert in the JDBC spec,
but it seems the other drivers I've tried do this.

~christopher






Message-ID: <09b801bfc36f$32b0d8a0$9500a8c0@styleadvisor.com>
Permalink:  ../09b801bfc36f$32b0d8a0$9500a8c0@styleadvisor.com/
Also on:    postgresql.org/message-id/09b801bfc36f$32b0d8a0$9500a8c0@styleadvisor.com

 · 

reply

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: christopher@baus.net, pgsql-interfaces@hub.org
  Subject: Re: date format question.
  In-Reply-To: <09b801bfc36f$32b0d8a0$9500a8c0@styleadvisor.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