mysql 查询一天内的记录

SELECT UNIX_TIMESTAMP(CURRENT_DATE) ;

SELECT DATE_ADD(CURRENT_DATE,INTERVAL 1 DAY)

SELECT UNIX_TIMESTAMP(DATE_ADD(CURRENT_DATE,INTERVAL 1 DAY))

 

三个常用函数NOW(),CURRENT_DATE  ,DATE_ADD()   ,DATE_SUB()

 

FROM_UNIXTIME(create_time,'%Y%m%d' )

 

call_Time>=STR_TO_DATE('2013-05-24 00:00:00','%Y-%m-%d %H:%i:%s')

转载于:https://www.cnblogs.com/dami520/archive/2013/05/23/3096012.html