How to convert java.sql.timestamp to LocalDate java.time?

How to convert java.sql.timestamp to LocalDate java.time?

To convert a java.sql.Timestamp to java.time.LocalDate in Java, you can use the following steps:

  1. Convert the java.sql.Timestamp to java.time.Instant.
  2. Convert the Instant to java.time.LocalDate.

Here's an example:

import java.sql.Timestamp; import java.time.Instant; import java.time.LocalDate; import java.time.ZoneId; public class TimestampToLocalDateExample { public static void main(String[] args) { // Create a java.sql.Timestamp (you can replace this with your Timestamp) Timestamp timestamp = Timestamp.valueOf("2023-11-05 12:34:56"); // Convert the Timestamp to Instant Instant instant = timestamp.toInstant(); // Convert Instant to LocalDate using a specific time zone ZoneId zoneId = ZoneId.systemDefault(); // or specify a different time zone LocalDate localDate = instant.atZone(zoneId).toLocalDate(); // Print the result System.out.println("Timestamp: " + timestamp); System.out.println("LocalDate: " + localDate); } }

In this example:

  1. We create a java.sql.Timestamp object named timestamp. You can replace this with your own Timestamp object.

  2. We convert the Timestamp to an Instant using the toInstant() method.

  3. We convert the Instant to a LocalDate by specifying a ZoneId (time zone) using the atZone(zoneId) method and then calling toLocalDate().

The resulting localDate will contain the date part of the original Timestamp, and the time part will be discarded. Adjust the ZoneId according to the desired time zone you want to use for the conversion.

More Tags

pyside css-position activity-stack cakephp-2.1 vqmod photosframework jaspersoft-studio valums-file-uploader mysql-udf fft

More Java Questions

More Chemistry Calculators

More Weather Calculators

More Gardening and crops Calculators

More Chemical reactions Calculators