String to Date Java

Question

I am trying to convert the string "5/23/14 02:23:24" from a String in Eclipse to a Date to insert into a SQL statement. The code I have is as follows:

String dateAndTime = "5/23/14 02:23:24";
SimpleDateFormat sdf = new SimpleDateFormat("MM/dd/yy HH:mm:ss");
Date date = sdf.parse(dateAndTime);
long dateLong = date.getTime();
insertStatement.setDate(1, new java.sql.Date(dateLong));

I expect to see

23-MAY-2014 2.23.24.000000000 PM

in my table, but instead I see

23-MAY-2014 12.00.00.000000000 AM

Can anyone shed some light on what I am doing wrong?

Thanks!

Check this answer by Jon. stackoverflow.com/questions/8530545/java-sql-date-time — Venkatesh
– Venkatesh, Commented May 23, 2014 at 16:40

rgettman · Accepted Answer · 2014-05-23 16:31:46Z

7

A standard DATE SQL type doesn't have any time information associated with it, so the javadocs for java.sql.Date state:

To conform with the definition of SQL DATE, the millisecond values wrapped by a java.sql.Date instance must be 'normalized' by setting the hours, minutes, seconds, and milliseconds to zero in the particular time zone with which the instance is associated.

You'll want to use a java.sql.Timestamp instead. It corresponds to the SQL type TIMESTAMP, which holds date and time of day data.

answered May 23, 2014 at 16:31

rgettman

179k30 gold badges282 silver badges365 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jon Skeet · Accepted Answer · 2014-05-23 16:31:08Z

6

You're calling setDate, which uses a java.sql.Date. That represents just a date, not a date and time.

You should consider using setTimestamp instead, with a java.sql.Timestamp. (There may be other ways of doing it for your specific database, but that's probably the simplest general solution):

long dateLong = date.getTime();
insertStatement.setTimestamp(1, new java.sql.Timestamp(dateLong));

answered May 23, 2014 at 16:31

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

Comments

Arvind Kumar Avinash · Accepted Answer · 2021-05-05 10:29:47Z

java.time

The legacy date-time API (java.util date-time types and their formatting API, SimpleDateFormat) is outdated and error-prone. It is recommended to stop using it completely and switch to java.time, the modern date-time API^*.

Solution using modern date-time API:

Parse the date-time string into LocalDateTime:

String dateAndTime = "5/23/14 02:23:24";
DateTimeFormatter dtf = DateTimeFormatter.ofPattern("M/d/uu H:m:s", Locale.ENGLISH);
LocalDateTime ldt = LocalDateTime.parse(dateAndTime, dtf);

Set the instance of LocalDateTime into the database using PreparedStatement#setObject:

Statement st = conn.createStatement();
PreparedStatement st = conn.prepareStatement("INSERT INTO mytable (columnfoo) VALUES (?)");
st.setObject(1, ldt);
st.executeUpdate();
st.close();

In order to read it from the database, use Resultset#getObject:

Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM mytable WHERE ...");
while (rs.next()) {
   LocalDateTime ldt = rs.getObject(1, LocalDateTime.class));
   System.out.println(ldt);
}
rs.close();
st.close();

Learn more about the the modern date-time API^* from Trail: Date Time.

^{* For any reason, if you have to stick to Java 6 or Java 7, you can use ThreeTen-Backport which backports most of the java.time functionality to Java 6 & 7. If you are working for an Android project and your Android API level is still not compliant with Java-8, check Java 8+ APIs available through desugaring and How to use ThreeTenABP in Android Project.}

Collectives™ on Stack Overflow

String to Date Java

3 Answers 3

Comments

Comments

java.time

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

java.time

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related