SQL query question

Question

I want to find the records of August birthdays in own table.I'm using Datetime Field.

Sample record:

01.08.2001
06.06.1985
26.08.1995

etc..

How should I do write a query?

Regards,

Answer 1

What's the db server you're working with? In SQL Server there's the MONTH function.

Your query could be something like:

Select *
from User u
where month(u.DOB) = 8