30天内如何选择数据?
我有查询:SELECT nameFROM (SELECT name FROM Hist_answerWHERE id_city='34324' AND datetime >= DATE_SUB(CURRENT_DATE,INTERVAL 1 MONTH)UNION ALLSELECT name FROM Hist_internetWHERE id_city='34324' AND datetime >= DATE_SUB(CURRENT_DATE,INTERVAL 1 MONTH)) xGROUP BY name ORDER BY name但是 DATE_SUB 是一个MySQL我需要函数MsSQL 2008的函数
请告诉我怎么用MsSQL 2008从30天内选择数据?
PS: 日期 时间数据类型 smalldatetime
解决方案:
你应该用的DATEADD是Sql因此,如果你尝试这个简单的选择,你会看到影响
Select DATEADD(Month,-1,getdate())结果
2013-04-20 14:08:07.177在您的情况下,请尝试此查询
SELECT nameFROM (SELECT name FROM Hist_answerWHERE id_city='34324' AND datetime >= DATEADD(month,-1,GETDATE())UNION ALLSELECT name FROM Hist_internetWHERE id_city='34324' AND datetime >= DATEADD(month,-1,GETDATE())) xGROUP BY name ORDER BY name
页:
[1]