我有表fc_Info,请问我查找3天内的sql怎么写?

Question

日期类型的字段如下:PublicDate
2005-9-25 11:50:39
2005-10-17 8:36:13
2005-10-22 8:34:08
2005-10-22 8:34:04
2005-10-27 17:55:45
2005-12-30 17:56:03
2005-12-30 17:56:01
2005-12-30 17:55:58
2005-11-13 12:29:52
2005-12-30 17:55:56
2005-10-27 17:55:55
2005-10-31 22:38:40
2005-10-31 22:37:23
2005-10-21 16:46:17
2005-10-8 9:29:07
2005-10-8 9:29:01
2005-10-11 11:55:15
2005-12-30 17:55:46
2005-12-30 17:55:43
2005-10-27 17:54:29
2005-10-27 17:54:26
2005-10-27 17:54:22
2005-10-27 17:54:18
2005-10-27 17:54:13

Answer 1

Declare @days
SET @days = Day(GETDATE())-Day(PublicDate)
IF @days < 4
...

Answer 2

在c#.net  如何写代码呢?

Answer 3

Select * From Table1 WHERE PublicDate >= DATEADD(d, -3, GETDATE())

Answer 4

datediff(dd,publicdate,getdate())  与3比较就是了。