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);
    }
}

Have Questions? Post them here!