mysql ʱ¼ä¶Î²éѯ

24СʱÄڼǼ£¨¼´86400Ã룩
$sql="SELECT video_id,count(id)as n from `rec_down` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(add_time)<=86400 group by video_id order by n desc ";
$sql="select a.id,a.title,b.n from video_info a,(".$sql.")b where a.id=b.video_id order by n desc limit 20";
NÌìÄڼǼ
WHERE TO_DAYS(NOW()) - TO_DAYS(ʱ¼ä×Ö¶Î) <= N
½ñÌìµÄ¼Ç¼
where date(ʱ¼ä×Ö¶Î)=date(now())
»ò
where to_days(ʱ¼ä×Ö¶Î) = to_days(now());
²éѯһÖÜ£º
select * from table   where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(column_time);
²éѯһ¸öÔ£º
select * from table where DATE_SUB(CURDATE(), INTERVAL INTERVAL 1 MONTH) <= date(column_time);
²éѯѡÔñËùÓÐ date_col ÖµÔÚ×îºó 30 ÌìÄڵļǼ¡£  
mysql> SELECT something from tbl_name
            WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) <= 30;    //Õæ·½±ã,ÒÔÇ°¶¼ÊÇ×Ô¼ºÐ´µÄ,¾¹È»²»ÖªµÀÓÐÕâ,ʧ°Ü.
DAYOFWEEK(date)  
·µ»Ø date µÄÐÇÆÚË÷Òý(1 = Sunday, 2 = Monday, ... 7 = Saturday)¡£Ë÷ÒýÖµ·ûºÏ ODBC µÄ±ê×¼¡£  
mysql> SELECT DAYOFWEEK(’1998-02-03’);
         -> 3
WEEKDAY(date)  
·µ»Ø date µÄÐÇÆÚË÷Òý(0 = Monday, 1 = Tuesday, ... 6 = Sunday)£º  
mysql> SELECT WEEKDAY(’1998-02-03 22:23:00’);
         -> 1
mysql> SELECT WEEKDAY(’1997-11-05’);
         -> 2
DAYOFMONTH(date)  
·µ»Ø date ÊÇÒ»ÔÂÖеĵڼ¸Ì죬·¶Î§Îª 1 µ½ 31£º  
mysql> SELECT DAYOFMONTH(’1998-02-03’);
         -> 3
DAYOFYEAR(date)  
·µ»Ø date ÊÇÒ»ÄêÖеĵڼ¸Ì죬·¶Î§Îª 1 µ½ 366£º  
mysql> SELECT DAYOFYEAR(’1998-02-03’);
         -> 34
MONTH(date)  
·µ»Ø date ÖеÄÔÂ