展开全部
这个看你用的什么数据库,还有你的自动是什么数据类型:
比如oracle,日期类型:
select * from tablea where datecol between add_months(trunc(sysdate(),-3) and trunc(sysdate()
如果是32313133353236313431303231363533e58685e5aeb931333365633938sqlserver
select * from tablea where datecol between dateadd(mm,-3,getdate()) and getdate();
/p>
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
Testfunction get3MonthBefor(){
var resultDate,year,month,date,hms;
var currDate = new Date();
year = currDate.getFullYear();
month = currDate.getMonth()+1;
date = currDate.getDate();
hms = currDate.getHours() + ':' + currDate.getMinutes() + ':' + (currDate.getSeconds() < 10 ? '0'+currDate.getSeconds() : currDate.getSeconds());
switch(month)