In Java, we can use Timestamp.valueOf(LocalDateTime) to convert a LocalDateTime into a Timestamp.

1. LocalDateTime <-> Timestamp

Java example to convert java.time.LocalDateTime to java.sql.Timestamp and vice verse.

TimeExample.java

package com.favtuts.time;

import java.sql.Timestamp;
import java.time.LocalDateTime;

public class LocalDateTimeToTimestamp {

    public static void main(String[] args) {
        convertLocalDateTimeFromToTimestamp();
    }

    static void convertLocalDateTimeFromToTimestamp() {
        // LocalDateTime to Timestamp
        LocalDateTime now = LocalDateTime.now();
        Timestamp timestamp = Timestamp.valueOf(now);

        System.out.println(now); // 2019-06-14T15:50:36.068076300
        System.out.println(timestamp); // 2019-06-14 15:50:36.0680763

        // Timestamp to LocalDateTime
        LocalDateTime localDateTime = timestamp.toLocalDateTime();

        System.out.println(localDateTime); // 2019-06-14T15:50:36.068076300
    }
}

Output

2022-06-05T18:10:04.772986
2022-06-05 18:10:04.772986
2022-06-05T18:10:04.772986

2. LocalDate <-> Timestamp

As title.

TimeExample2.java

package com.favtuts.time;

import java.sql.Timestamp;
import java.time.LocalDate;
import java.time.LocalDateTime;

public class LocalDateTimeToTimestamp {

    public static void main(String[] args) {
        convertLocalDateFromToTimestamp();
    }

    static void convertLocalDateFromToTimestamp() {
        // LocalDate to Timestamp
        LocalDate now = LocalDate.now();
        Timestamp timestamp = Timestamp.valueOf(now.atStartOfDay());

        System.out.println(now); // 2019-06-14
        System.out.println(timestamp); // 2019-06-14 00:00:00.0

        // Timestamp to LocalDate
        LocalDate localDate = timestamp.toLocalDateTime().toLocalDate();
        System.out.println(localDate); // 2019-06-14
    }
}

Output

2022-06-05
2022-06-05 00:00:00.0
2022-06-05

Download Source Code

$ git clone https://github.com/favtuts/java-core-tutorials-examples

$ cd java-basic/time

References

• Java 8 – How to format LocalDateTime
• LocalDate JavaDocs
• LocalDateTime JavaDocs
• Timestamp JavaDocs