mysql日期函数总结
SELECT *
FROM product AS r1 JOIN
(SELECT ROUND(RAND() *
(SELECT MAX(product_id)
FROM product)) AS product_id)
AS r2
WHERE r1.product_id >= r2.product_id
ORDER BY r1.product_id ASC
LIMIT 5;
SELECT GROUP_CONCAT(product_id,'_') FROM product;
SELECT MONTHNAME('2011-03-01');
SELECT TIMESTAMPDIFF(MONTH,'2011-01-11','2013-01-11')
SELECT TO_DAYS('0000-01-01')/365
SELECT DATE_SUB(NOW(),INTERVAL 10 DAY),DATE_ADD(NOW(),INTERVAL 10 DAY)
SELECT DAYOFWEEK(NOW());
SELECT WEEKDAY(NOW())
SELECT DAYOFMONTH(NOW());
SELECT DAYOFYEAR(NOW())
SELECT MONTH(NOW());
SELECT DAYNAME(NOW());
SELECT EXTRACT(DAY FROM NOW())
SELECT DATE_FORMAT(NOW(),'%Y-%m-%d %h:%m:%s %W %p %M %D')
SELECT CURRENT_DATE();
SELECT NOW();