mysql的期和时间函数.docVIP

HYPERLINK /pcnet/database/mysql/index.html \t _blank mysql的日期和时间函数? 这里是一个使用日期函数的例子。下面的查询选择所有?date_col?值在最后?30?天内的记录。??  HYPERLINK /pcnet/database/mysql/index.html \t _blank 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?的标准。??  HYPERLINK /pcnet/database/mysql/index.html \t _blank mysql?SELECT?DAYOFWEEK(’1998-02-03’);? ????????-?3? WEEKDAY(date)?? 返回?date?的星期索引(0?=?Monday,?1?=?Tuesday,?...?6?=?Sunday)：??  HYPERLINK /pcnet/database/mysql/index.html \