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

Re: Bad value for type date

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: dbadmin(at)nqadmin(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Bad value for type date
Date: 2005-08-20 13:10:56
Message-ID: 43072BE0.9000306@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Prasanth wrote:

> Below is a small program to test the JDBC date issue I have having.
> 
> I am able to set the date "2/1/10000". But it fails to retrieve it.
> 
> If it is invalid date then it should not even update the database right?

I can't reproduce this; the attached testcase produces this against my
8.0 install:

Inserting date: 10000-02-01 AD +1300
Got date: 10000-02-01 AD +1300
Got date: 10000-02-01 AD +1300

I get this using both the -310 driver and a build from CVS HEAD.

You'll need to give us a compilable testcase that shows the problem to
take this any further. The code you provided originally doesn't compile
out-of-the-box, is missing schema information, and has a syntactically
incorrect query..

It'd also help if you can reproduce your problem without involving a
RowSet implementation.

-O

Attachment: TestDate2.java
Description: text/plain (1.2 KB)

In response to

Responses

pgsql-jdbc by date

Next:From: PrasanthDate: 2005-08-20 16:16:37
Subject: Re: Bad value for type date
Previous:From: Maciej JaźwińskiDate: 2005-08-20 05:56:39
Subject: Strange error when using varbit

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