1

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,

Cell-o
  • 1,088
  • 8
  • 21
  • 37
  • 2
    It is always best to mention what platform you are working in, as different platforms will have different solutions. – mrdenny Aug 04 '11 at 19:36

1 Answers1

3

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
Marian
  • 15,531
  • 2
  • 60
  • 74