Inserting 'Dates' in database
От | Dan McDaniel |
---|---|
Тема | Inserting 'Dates' in database |
Дата | |
Msg-id | 587C9ED8EF99D3118DCD00508B115FF29103D3@EXCH1 обсуждение исходный текст |
Ответы |
Re: Inserting 'Dates' in database
Re: Inserting 'Dates' in database |
Список | 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
В списке pgsql-jdbc по дате отправления: