Mican Bican wrote:
> How can I store a java.sql.date as null in database. The problem is
Real test code would be much better.
> ..insert into Customer (id..,date,...)
> ...." ' "+in.getSqlDate()+" ' ".....
If in.getSqlDate() returns null, this turns into:
insert into Customer (...) values (... 'null' ...)
which is wrong -- the NULL should be unquoted.
I'd suggest using a java.sql.PreparedStatement and parameter
placeholders, then you don't need to worry about the details of "how do
I represent a date in the right format for this DB?"
In response to
pgsql-jdbc by date
|Next:||From: Oliver Jowett||Date: 2005-03-07 20:06:37|
|Subject: Re: postgre 7.3 / JSTL problem|
|Previous:||From: Mican Bican||Date: 2005-03-07 20:01:26|
|Subject: Convert java.sql.Date to java.util.Date|