Java Data Type How to - Convert ZonedDateTime to java.sql.Timestamp

Question

We would like to know how to convert ZonedDateTime to java.sql.Timestamp.

Answer

import java.sql.Timestamp;
import java.time.ZonedDateTime;
//  w  w w  .  ja va2 s  .c o m
public class Main {

  public static void main(String[] args) {
    System.out.println(toTimestamp(ZonedDateTime.now()));
  }

  public static Timestamp toTimestamp(ZonedDateTime dateTime) {
    return new Timestamp(dateTime.toInstant().getEpochSecond() * 1000L);
  }

}

The code above generates the following result.