How to convert Java LocalDateTime to Timestamp Object with Examples


Java 8 introduced a new API for Data & Time (package java.time) that introduced the class LocalDateTime that can be used to represent date-time without a time-zone in the ISO-8601 calendar system, such as 2023-03-22T11:12:13

In order to convet LocalDateTime into a java.sql.Timestamp obejct we will need to make use convert the LocalDateTime into an Instant type and then Timestamp.from() method.

Code Example 1: If need to make use of Time Zone
import java.sql.Timestamp;
import java.time.Instant;
import java.time.LocalDateTime;
import java.time.ZoneId;
import java.time.ZonedDateTime;


 public class Main {
    public static void main(String[] args) {

        //Step 1: Get the LocalDateTime Object
        LocalDateTime localDateTime = LocalDateTime.now();

        //Step 2: Convert to ZonedDateTime
        ZonedDateTime zonedDateTime = localDateTime.atZone(ZoneId.of("America/New_York"));

        //Step 3: Get Instant from ZonedDateTime
        Instant instant = zonedDateTime.toInstant();

        //Step 4: Create Timestamp object from Instant object
        Timestamp timestamp = Timestamp.from(instant);

        System.out.println("Local Date Time to instant: " + instant);
        System.out.println("Local Date Time: " + localDateTime);
        System.out.println("Timestamp: "+ timestamp);
    }
}
Output:

Local Date Time: 2023-03-22T15:02:13.021877
Local Date Time to instant: 2023-03-22T01:13:13.021877Z
Timestamp: 2023-03-23 01:13:13.021877


Code Example 2: When need to convert to Timestamp in the same timezone (or ZoneId.systemDefault())
import java.sql.Timestamp;
import java.time.LocalDateTime;


public class Main {
    public static void main(String[] args) {
        
        LocalDateTime localDateTime = LocalDateTime.now();
        Timestamp timestamp = Timestamp.valueOf(localDateTime);

        System.out.println("Local Date Time: " + localDateTime);
        System.out.println("Timestamp: "+ timestamp);
    }
}
Java Convert LocalDateTime to Java SQL Timestamp object code output
-

Facing issues? Have Questions? Post them here! I am happy to answer!


Author Info:

Rakesh (He/Him) is a seasoned developer with over 10 years of experience in web and app development, and a deep knowledge of operating systems. Author of insightful How-To articles for Code2care.

Follow him on: X

You can also reach out to him via e-mail: rakesh@code2care.org

Copyright © Code2care 2024 | Privacy Policy | About Us | Contact Us | Sitemap