Inserting 'Dates' in database

From: Dan McDaniel <Dan-McDaniel(at)smh(dot)com>
To: "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Inserting 'Dates' in database
Date: 2002-04-08 21:58:59
Message-ID: 587C9ED8EF99D3118DCD00508B115FF29103D3@EXCH1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


I am writing a simple Java user interface to a simple data base in
Postgresql.
I have no trouble connecting through my code using the JDBC driver. I can
get several different Resultsets back with no problem. I am having trouble
inserting data into the database. In particular Date data types. I get a
message that says "Bad Date external representation".
Here is how I am trying to solve the problem:
I am getting a text string from the user interface and storing it in a
String varialble called " dateInsert".
Using a method I wrote call "convertDate()" , I am converting this date
first to a java.util.Date object, a time object and finally to a
java.sql.Date object called "sqldate" which I include in the Insert
statement.

here is the code snippet for the "convertDate() method:
<pre>
public java.sql.Date convertDate()
{
java.util.Date adate;
DateFormat fmt = DateFormat.getDateInstance(DateFormat.SHORT,
Locale.US);
try {
aDate = fmt.parse(dateInsert); // dateInsert is String from
JTextPane;
long time = aDate.getTime();
sqldate = new java.sql.Date(time);
}
catch (ParseException e)
{
System.out.println(e);
}
return sqldate;
} //end of convertDate()
</pre>

I pent allmost 18 hours trying to work this out yesterday and have run out
of ideas. Can anyone suggest a direction for me?

Thanks
Dan McDaniel
Director of Architecture and Facility Planning
ext. 2048
beeper 1152

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2002-04-09 00:01:46 Re: JDBC Driver Problem
Previous Message Barry Lind 2002-04-08 16:58:57 Re: raw data broken in 7.2 driver?