Java examples to convert from
java.sql.Time and vice versa.
Note that the
Time class adds formatting and parsing operations to support the JDBC escape syntax for time values. Its date components should be set to the “zero epoch” and should not be accessed.
1. Convert LocalTime to java.sql.Time
java.sql.Time.valueOf() method to get SQL time from
LocalTime instance. Such time instance contains the same hour, minute and second-time value as localtime.
The nanosecond field from
LocalTime is not part of the newly created
LocalTime now = LocalTime.now(); Time time = Time.valueOf( now ); System.out.println(time); //13:54:20
2. java.sql.Time to LocalTime
java.sql.Time.toLocalTime() method to get
LocalTime with the same hour, minute, and second-time value as this
Time. The nanosecond
LocalTime field will be set to zero.
//Get SQL time instance java.sql.Time sqlTime = new Time(new Date().getTime()); //Get LocalTime from SQL time LocalTime localTime = sqlTime.toLocalTime(); System.out.println( localTime ); //14:00:33
Happy Learning !!