2. it
  3. sql 时间查询

sql 时间查询

mac2022-06-30  22

sql 时间查询

参考资料

https://www.cnblogs.com/zjdxr-up/p/8383693.html

 

使用 between and或者是< >操作符。

SELECT * FROM tbl_student_info WHERE `createDate` between '20170101020304' and '20180101020304' 等同于 SELECT * FROM tbl_student_info WHERE `createDate` >= '20170101020304' and `createDate` <= '20180101020304'

 

最新回复(0)