getDateTime from ResultSet java

java mysql datetime resultset
Luc picture Luc · Apr 3, 2013 · Viewed 36.4k times · Source

I have two columns which store DateTime values in a MySql database,

When I try to get them from a ResultSet in Java there is no option: getDateTime()

Should I use getDate() or wouldn't that work?

Thanks in advance

Answer

tmwanik picture tmwanik · Apr 3, 2013

Using getDate() only returns a Date, so in your case if you want both date and time use getTimestamp(String columnLabel) - That should work, also replace String columnLabel with the actual column name in the database.

Related questions

How to store Java Date to Mysql datetime with JPA

Can any body tell me how can I store Java Date to Mysql datetime...? When I am trying to do so...only date is stored and time remain 00:00:00 in Mysql date stores like this... 2009-09-22 00:00:00 I want not only …

Read More
A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)

So far, I have not found a clear answer to this. I'd like to know what the equivalent is for a SQL type DATETIME and the java type, using a PreparedStatement. I have found: http://www.java2s.com/Code/…

Read More
How do I set a full date & time sql using java, and not just the date?

I am trying to set a timestamp in my database using java, however in my table all I get is the date, and no time (i.e., looks like "2010-09-09 00:00:00"). I am using a datetime field on my mysql …

Read More