sqlite 模糊匹配日期_sql模糊查询和根据日期筛选

   >= 小于等于      <=大于等于

将字符类型转换成日期格式进行比较

select * from xy_platformMessage

and approval_status=#{approval_status}

and STR_TO_DATE(announcement_date,'%Y-%m-%d') >= STR_TO_DATE(#{start_date},'%Y-%m-%d')

and STR_TO_DATE(announcement_date,'%Y-%m-%d') <= STR_TO_DATE(#{end_date},'%Y-%m-%d')

order by announcement_date desc

select u.*,p.ProductName from xy_pdf_untowardReaction u left join xy_ccproduct p

on u.SerialNum=p.SerialNum

where u.company_id=#{company_id}

and (p.ProductName like '%%${ProductName}%%')

and STR_TO_DATE(u.add_time,'%Y-%m-%d') >= STR_TO_DATE(#{start_date},'%Y-%m-%d')

and #{end_date} >= STR_TO_DATE(u.add_time,'%Y-%m-%d')

order by u.add_time desc

2.

SELECT

`id`,

`no`,

`SerialNum`,

`date_of_occurrence`,

`time_frame`,

`interval_month`,

`birthday`,

`sex`,

`weight`,

`nation`,

`height`,

`city_a`,

`human_race`,

`untoward_reaction_name`,

`level`,

`new_or_old`,

`table`

FROM

xy_survey_compute

WHERE SerialNum=#{SerialNum}

and company_id=#{company_id}

AND STR_TO_DATE(`date_of_occurrence`,'%Y-%m-%d %H:%i:%s') >= STR_TO_DATE(CONCAT(#{start_date},' 00:00:01'),'%Y-%m-%d %H:%i:%s')

AND STR_TO_DATE(`date_of_occurrence`,'%Y-%m-%d %H:%i:%s') <=STR_TO_DATE(CONCAT(#{end_date},' 23:59:59'),'%Y-%m-%d %H:%i:%s')