jpa mysql date_Springboot JPA + MySQL Date between 坑...

spring.datasource.url=jdbc:mysql://rm-xxyy.mysql.rds.aliyuncs.com:3306/dev_db?generateSimpleParameterMetadata=true&useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai

泪... 一早上就为了这一句;

随便写了个 JPA 方法 select , where xxDate between ${from} and ${to}. 取一天内的数据, 怎么都出不来, 各种查doc.就因为少配了timeZone

serverTimezone=Asia/Shanghai

-------------------多说一句:

入参如下:

java.util.Date from = DateUtils.parseDate("2019-03-24 10:35:00", CommonDateUtils.DATE_TIME_FORMAT);

java.util.Date to = DateUtils.parseDate("2019-03-25 10:34:59", CommonDateUtils.DATE_TIME_FORMAT);

表里数据如下:

方法名里写between, 取不出来. 如下

xxRepo.findByEmailHasSentAndOptTimeBetween(NumberUtils.INTEGER_ZERO, from, to);

无奈改成了:

@Query(value = "SELECT * FROM reg_step_log WHERE email_has_sent = ?1 and opt_time >= ?2 and opt_time <= ?3",

nativeQuery = true)

List findByEmailHasSentAndOptTimeBetween(Integer emailHasSent, Date optTimeStart, Date optTimeEnd);

具体原因不细究了, 没空.