MySQL datetime not returning time

Question

I have a MySQL db with a table containing a datetime column.

However, I cannot find a way in Java to return this as some sort of Time object within Java.

I can call resultset.getString("Date") and it will return the datetime, but this is no good as there is no way to compare dates, etc., on the string.

I can also call resultset.getDate("Date"), but this doesn't return the time at all.

possible duplicate of Handling MySQL datetimes and timestamps in Java — BalusC
– BalusC, Commented Oct 25, 2011 at 1:07

NightWolf · Accepted Answer · 2011-10-25 00:56:37Z

8

You need to use the getTime() or getTimestamp() methods as suggested in the comment by Thomas. To give an example however...

Say for a table you query like this: rs = stmt.executeQuery("select timeCol, dateCol, dateTimeCol from dateTimeTable");

You could do:

java.sql.Time dbSqlTime = rs.getTime(1);
java.sql.Date dbSqlDate = rs.getDate(2);
java.sql.Timestamp dbSqlTimestamp = rs.getTimestamp(3);

If you want to use the Java date object:

java.util.Date dbSqlTimeConverted = new java.util.Date(dbSqlTime.getTime());
java.util.Date dbSqlDateConverted = new java.util.Date(dbSqlDate.getTime());

I would also check out JodaTime for working with Dates in Java, makes life much simpler.

Finally, its worth noting that there are a few differences between Timestamp and DateTime in MySQL. Namely that Timestamp has a timezone and the server will return a queried Timestamp in the Server's local time (which can be annoying). My advice is to use DateTime and always keep dates/times in the same timezone (i.e. UTC). See http://dev.mysql.com/doc/refman/5.0/en/datetime.html

edited Oct 25, 2011 at 0:56

answered Oct 24, 2011 at 12:03

NightWolf

7,79411 gold badges78 silver badges123 bronze badges

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

1 Comment

BalusC Over a year ago

java.sql.Timestamp is a subclass of java.util.Date. You can just upcast instead of recreating it.

Salim R · Accepted Answer · 2014-10-01 06:19:56Z

1

Just to clarify, only getTimesStamp() will return the Date and time in one shot when querying Mysql :

Column: startTime: value: 2014-09-29 20:49:41

Java:

java.sql.Timestamp dbSqlTimestamp = rs.getTimestamp("startTime");
System.out.println("dbSqlTimestamp="+dbSqlTimestamp);

output: dbSqlTimestamp=2014-09-29 20:49:41.0

answered Oct 1, 2014 at 6:19

Salim R

3437 silver badges16 bronze badges

Collectives™ on Stack Overflow

MySQL datetime not returning time

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related