Question

查询3天之内过生日的人的sql代码怎么写啊？

select name from XX where datediff(mm,[列名],getdate) = 0 and 0<= datediff(dd,[列名],getdate) <=3
这样写可以吗？

Answer 1

你的语法有问题，不能0<=xxx<=3的，且GetDate少了().
Select Name From XX Where Datediff(d,getDate(),[列名])<=3 And Datediff(d,getDate(),[列名])>=0。查的就是该月3天之内过生日的人了。

Answer 2

0<= datediff(dd,[列名],getdate) <=3

你以为些数学表达式呢
你这里至少也要拆成两个and嘛

and datediff(dd,[列名],getdate) <=3
and datediff(dd,[列名],getdate) >=0

Answer 3

不一定是本月啊，试试这个：

select name from XX where convert(varchar(10),[列名],120) >= convert(varchar(10),getdate(),120)
and
convert(varchar(10),[列名],120) <= convert(varchar(10),dateadd(dd,3,getdate()),120)

Answer 4

SELECT [name]
FROM [XX]
WHERE DATEPART(mm, [列名]) = DATEPART(mm, GETDATE())
AND ABS(DATEPART(dd, [列名]) - DATEPART(dd, GETDATE())) <= 3

Answer 5

select name from XX where datepart(mm,列名)=datepart(mm,getdate()) and
datepart(day,列名)-datepart(day,getdate()) between 0 and 3