How to convert String to Java.sql.date and Java.sql.time

Question

Hello

If I have a method like this:

public static String convertDateTimeToString(DateTime dt) {
    return dt.getDate() + " " + dt.getTime();
}

Which takes a Datetime object of my own which contains a Java.sql.date and a Java.sql.time, what is the best way of reversing the process so that I can substring a Java.sql.date and a Java.sql.time from a string?

Or if DateTime dt is a JodaTime DateTime object?

If this can be done without reference to Java.util.date.

Thanks

Mr Morgan.

Answer 1

Look at SimpleDateFormat class. Here's a tutorial.

You'll need something like this:

String datetimeString;
Date result;
SimpleDateFormat formatter = new SimpleDateFormat("EEE d MMM yy hh:mm:ss");
result = formatter.parse (datetimeString);

Answer 2

You can use the valueOf method of java.sql.Time to convert a String into a java.sql.Time, and use the valueOf method of java.sql.Date to convert a String into a java.sql.Date