将LocalDate转换为LocalDateTime或java.sql.Timestamp

LocalDateTime ldt = new LocalDateTime();
DateTimeFormatter dtf = DateTimeFormatter.forPattern("yyyy-MM-dd HH:mm:ss");
Timestamp ts = Timestamp.valueOf(ldt.toString(dtf));

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

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

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

Timestamp timestamp = Timestamp.valueOf(localDateTime);

new Timestamp(localDateTime.getYear() - 1900, localDateTime.getMonthOfYear() - 1, localDateTime.getDayOfMonth(), localDateTime.getHourOfDay(), localDateTime.getMinuteOfHour(), localDateTime.getSecondOfMinute(), fractional);

  LocalDateTime ldt = timeStamp.toLocalDateTime();
  Timestamp ts = Timestamp.valueOf(ldt);

@Converter(autoApply = true)
public class LocalDateTimeConverter implements AttributeConverter<LocalDateTime, Timestamp> {
    @Override
    public Timestamp convertToDatabaseColumn(LocalDateTime ldt) {
        return Timestamp.valueOf(ldt);
    @Override
    public LocalDateTime convertToEntityAttribute(Timestamp ts) {
        return ts.toLocalDateTime();

推荐文章

爱笑的蜡烛 · Importing Tester requires importing all of UnitTest which is not a AttributeError: module 'numpy' h

10 月前

会开车的蘑菇 · jquery字符串转日期-掘金

1 年前

爱看书的盒饭 · SQL Cookbook读书笔记（更新ing） - 知乎

2 年前

帅气的鼠标 · cv2.imread 中文路径-掘金

2 年前

飞翔的遥控器 · Qt之‘qsrand’未找到，原因以及解决方案_生活vs诗和远方的博客-CSDN博客

2 年前

将LocalDate转换为LocalDateTime或java.sql.Timestamp

5 个回答