Johnny Huang的博客

select         news0_.id as id0_,         news0_.cdate as cdate0_,         news0_.clicks as clicks0_,         news0_.content as content0_,         news0_.editor as editor0_,         news0_.htmlP

DAYOFWEEK(date) 　返回日期date是星期几(1=星期天,2=星期一,……7=星期六,ODBC标准) mysql> select DAYOFWEEK('1998-02-03'); 　　-> 3 WEEKDAY(date) 　返回日期date是星期几(0=星期一,1=星期二,……6= 星期天)。 mysql> select WEEKDAY('1997-10-04