hlb

摘要： 24小时内记录（即86400秒）$sql="SELECT video_id,count(id)as n FROM `rec_down` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(add_time) SELECT something FROM tbl_name WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) SELECT DAYOFWEEK(’1998-02-03’); -> 3 WEEKDAY(date) 返回 date 的星期索引(0 = Monday, 1 = Tuesday, ... 6 = S 阅读全文