mybatis mysql 时间字符串 转 date ( 查询 )
- and create_time <= str_to_date(#{createTime},’%Y-%m-%d %H:%i:%s’)
- and DATE_FORMAT(create_time,’%Y-%m-%d %H:%i:%s’) >= DATE_FORMAT(#{queryStartTime},’%Y-%m-%d %H:%i:%s’)
- and create_time >= DATE_FORMAT(#{queryStartTime},’%Y-%m-%d %H:%i:%s’)
参考.