mysql UNIX_TIMESTAMP FROM_UNIXTIME 了解一下
select * from wap_login where UNIX_TIMESTAMP(creat_date) between UNIX_TIMESTAMP('2018-07-26 00:00:00') and UNIX_TIMESTAMP('2018-07-26 23:59:59')
select * from wap_login where creat_date between '2018-07-26 00:00:00' and '2018-07-26 23:59:59'
select * from wap_login where creat_date between UNIX_TIMESTAMP('2018-07-01 00:00:00') and UNIX_TIMESTAMP('2018-07-26 23:59:59')
select * from wap_login where creat_date < '2018-07-01 00:00:00'
select * from wap_login where UNIX_TIMESTAMP(creat_date) between UNIX_TIMESTAMP('2018-07-26 00:00:00') and UNIX_TIMESTAMP('2018-07-26 23:59:59')
select * from wap_login where creat_date between '2018-07-26 00:00:00' and '2018-07-26 23:59:59'
select * from wap_login where UNIX_TIMESTAMP(creat_date) < 1530374400
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。