Convert LocalDate to LocalDateTime or java.sql.Timestamp

by

JodaTime

To convert JodaTime’s org.joda.time.LocalDate to java.sql.Timestamp, just do

Timestamp timestamp = new Timestamp(localDate.toDateTimeAtStartOfDay().getMillis());

To convert JodaTime’s org.joda.time.LocalDateTime to java.sql.Timestamp, just do

Timestamp timestamp = new Timestamp(localDateTime.toDateTime().getMillis());

JavaTime

To convert Java8’s java.time.LocalDate to java.sql.Timestamp, just do

Timestamp timestamp = Timestamp.valueOf(localDate.atStartOfDay());

To convert Java8’s java.time.LocalDateTime to java.sql.Timestamp, just do

Timestamp timestamp = Timestamp.valueOf(localDateTime);

More Related Contents:

  1. Convert Date/Time for given Timezone – java
  2. Convert timestamp in milliseconds to string formatted time in Java
  3. How to find difference between two Joda-Time DateTimes in minutes
  4. Converting a date string to a DateTime object using Joda Time library
  5. How to calculate elapsed time from now with Joda-Time?
  6. Creation timestamp and last update timestamp with Hibernate and MySQL
  7. Period to string [duplicate]
  8. Current time in microseconds in java
  9. Using Joda Date & Time API to parse multiple formats
  10. String to LocalDate
  11. How to get the current date and time of your timezone in Java?
  12. Java Date cut off time information
  13. How to get start and end range from list of timestamps?
  14. Understanding the Etc/GMT time zone
  15. Get the week start and end date given a current date and week start
  16. Timestamp convert [duplicate]
  17. Joda-Time: what’s the difference between Period, Interval and Duration?
  18. Android Get Current timestamp?
  19. How to convert HH:mm:ss.SSS to milliseconds?
  20. Java Timestamp – How can I create a Timestamp with the date 23/09/2007?
  21. joda time – add weekdays to date
  22. How to convert TimeStamp to Date in Java?
  23. Time: How to get the next friday?
  24. Convert from java.util.date to JodaTime
  25. hibernate 4 and joda-time
  26. difference in seconds between two dates using joda time?
  27. Formatting timestamp in Java
  28. Are there any cons to using Joda-Time?
  29. How to handle jodatime Illegal instant due to time zone offset transition
  30. Why Joda DateTimeFormatter cannot parse timezone names (‘z’)

Leave a Comment