How to insert a date from form to a column whose type is Datetime in database

Question

I got the date which is a string from a form. The date looks like xxxx-xx-xx xx:xx:xx

How can I save this date string to a column whose type is datetime in the database.

I use PreparedStatement psta = new PreparedStatement(sql) to set the values for the sql.

So for the Datetime type column, when i pre-set the value. I should use psta.setDate() or use psta.setString()?

use [SimpleDateFormat](https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html) to convert String to Date, then use `setDate()` — Scary Wombat, Feb 22 '17 at 06:16

score 1 · Accepted Answer · answered Feb 22 '17 at 06:24

1

Please ignore all the comments and other answers that says to use setDate(). Instead, you have to use setTimestamp(), because your date string has time-of-day (hour, minute, second).

First, you have to parse the text using SimpleDateFormat.
Then convert from java.util.Date to java.sql.Timestamp.
Finally call setTimestamp().

All in all, like this:

SimpleDateFormat fmt = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
java.util.Date date = fmt.parse(dateString);
psta.setTimestamp(1, new java.sql.Timestamp(date.getTime()));

answered Feb 22 '17 at 06:24

Andreas

154,647
11
152
247

I use setTimestamp. But an error, java.sql.SQLException: Column count doesn't match value count at row 1, is thrown. I checked the number of my parameters and the name of parameters with the columns in the table. It is the same – Will Feb 22 '17 at 07:01
@Will You'd have to show more of your code for help with that, but that's a different question. This is the answer to this question. Create another question for problem matching up `setXxx()` calls with `?` markers in your SQL statement. – Andreas Feb 22 '17 at 07:12
@ Andreas Thank you so much, and i fixed the error. :) – Will Feb 22 '17 at 07:36

score 0 · Answer 2 · edited Jun 20 '20 at 09:12

0

Use SimpleDateFormat to convert your String to Date.

ref: How to convert a String to a Date using SimpleDateFormat?
Use psta.setDate() to set date for your sql query.

ref : Using setDate in PreparedStatement

edited Jun 20 '20 at 09:12

Community

1
1

answered Feb 22 '17 at 06:21

Raman Sahasi

30,180
9
58
71

How to insert a date from form to a column whose type is Datetime in database

2 Answers2