如果你的是sql server 就用select * from tblname where ... group by datepart(yy,日期字段) --按年
select * from tblname where ... group by datepart(qq,日期字段) --按季度
select * from tblname where ... group by datepart(mm,日期字段) --按月
select * from tblname where ... group by datepart(dd,日期字段) --按日
select * from tblname where ... group by datepart(ww,日期字段) --按周
select * from tblname where ... group by datepart(qq,日期字段) --按季度
select * from tblname where ... group by datepart(mm,日期字段) --按月
select * from tblname where ... group by datepart(dd,日期字段) --按日
select * from tblname where ... group by datepart(ww,日期字段) --按周
$daynum='15';//define by condition
$eddte=date("Y-m-d");
$bgdte=date("Y-m-d",mktime(0,0,0,date('m'),date('d')-$daynum,date('Y')));
$sql="select * from tablename where datefield<=".$eddte." and datefield>=".$bgdte;?>
$query = "SELECT * FROM table WHERE (TO_DAYS(CURRENT_DATE)-TO_DAYS(datefield))>15";
// 一个月前
$query = "SELECT * FROM table WHERE (TO_DAYS(CURRENT_DATE)-TO_DAYS(datefield))>30";
// 三个月前
$query = "SELECT * FROM table WHERE (TO_DAYS(CURRENT_DATE)-TO_DAYS(datefield))>90";类推...
$query = "SELECT * FROM table WHERE (TO_DAYS(CURRENT_DATE)-TO_DAYS(datefield))>15";
// 一个月前
$query = "SELECT * FROM table WHERE (TO_DAYS(CURRENT_DATE)-TO_DAYS(datefield))>30";
// 三个月前
$query = "SELECT * FROM table WHERE (TO_DAYS(CURRENT_DATE)-TO_DAYS(datefield))>90";类推...
to_days()是一个涵数吗?
有没有搞错,你盗版也太厉害了吧,居然一字不漏地照抄一遍!
TO jeanyli(别问我) :
直接用就可以了。
// 15天前
"SELECT * FROM table WHERE TO_DAYS($current_date)-TO_DAYS(newdate)>=15 ";
//newdate 是数据库里的字段.格式如: 2002-12-20 23:12:22以上语句是否正确?
laugh
不需要用PHP取当前时间了,在MYSQL中CURRENT_DATE就是当前时间。