Default JDBC date format when reading date as a string from ResultSet

Question

I'm looking at some code that basically does the following:

ResultSet rs = ps.executeQuery();
String myDateStr = rs.getString("MY_DATE"); //field is of type Date
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss'.0'");
Date myDate = sdf.parse(myDateStr);

On some environments the last line works, and on others it throws an Unparseable date exception. It looks like on some systems the default date format is 2013-01-25 00:00:00.0, and on others 2013-01-25 00:00:00. The JVM, OS and Oracle version are different between the environments (all use Oracle and run on a unix variant though).

Changing the code might be complex. I'm wondering if there is an environment variable or similar that can be set to make the date format returned from rs.getString() consistent?

Answer 1

try this:

ResultSet rs = ps.executeQuery();

Date myDate = rs.getDate("MY_DATE"); 

or this :

ResultSet rs = ps.executeQuery();
String myDateStr = rs.getString("MY_DATE"); 
Date myDate = valueOf(myDateStr);

More about date: http://docs.oracle.com/javase/7/docs/api/java/sql/Date.html
More about ResultSet : http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html

Answer 2

Instead of using

String myDateStr = rs.getString("MY_DATE") 

you should use

Timestamp timestamp = rs.getTimestamp("MY_DATE");

JDBC / Database will handle the date transformation for you.