求几个关于日期处理的sql语句

[ice241018]

表名：A
id content ptime
1 123 2004-8-17 10:20:53
2 456 2004-8-18 3:34:55
....
200 673 2006-6-7 10:20:53

我现在要按照时间提取今日的数据，最近一周的数据和最近一月内的数据

我会尽快揭贴

[itblog]

--今日的数据

select * from A where datediff(day,ptime,getdate())=0

[paoluo]

Select * From A Where DateDiff(dd,ptime,GetDate())=0
Select * From A Where DateDiff(wk,ptime,GetDate())=0
Select * From A Where DateDiff(mm,ptime,GetDate())=0

[paoluo]

--本日
Select * From A Where DateDiff(dd,ptime,GetDate())=0
--本周
Select * From A Where DateDiff(wk,ptime,GetDate())=0
--本月
Select * From A Where DateDiff(mm,ptime,GetDate())=0

[itblog]

WO！快啊~鱼昨天一天不在啊~

[xeqtr1982]

快~

[paoluo]

忙了，今天也是很少答題了，最近幾個星期都會是這樣了。