Month closest actual month

Question

i have this table:

Players:
ID (int)
Birthday (datetime)

I need choose 3 first players, which have birthday in the actual month... I have this but the result is nothing.. Have you any idea?

SELECT * 
FROM Players
WHERE Birthday < DATEADD(month, -2, GETDATE())

score 3 · Answer 1 · answered Jun 20 '13 at 11:03

3

You need to use DATEPART function in SQL server

SELECT * 
FROM Players
WHERE DATEPART(MM,Birthday) = DATEPART(MM,GETDATE())

answered Jun 20 '13 at 11:03

1

Kate says: I need choose 3 first players. does your query will return 3 first player? – Rezoan Jun 23 '13 at 12:35

score 1 · Accepted Answer · answered Jun 20 '13 at 11:04

1

Using SQL Server syntax:

select  top 3 *
from    YourTable
where   datepart(month, Birthday) = datepart(month, getdate())

answered Jun 20 '13 at 11:04

Andomar

2 Answers2