mysql常用的东西

1.时间戳转换为日期格式

SELECT FROM_UNIXTIME( 1249488000, '%Y%m%d' )  

2.查询当前这周的数据 

SELECT name,submittime FROM enterprise WHERE YEARWEEK(date_format(submittime,'%Y-%m-%d')) = YEARWEEK(now());

3.查询上周的数据

SELECT name,submittime FROM enterprise WHERE YEARWEEK(date_format(submittime,'%Y-%m-%d')) = YEARWEEK(now())-1;