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,

It is always best to mention what platform you are working in, as different platforms will have different solutions. — mrdenny, Aug 4, 2011 at 19:36

Marian · Accepted Answer · 2011-08-04 17:23:03Z

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

answered Aug 4, 2011 at 17:23

Marian

15.4k2 gold badges57 silver badges73 bronze badges

Concise + straightforward = +1 !!!
– RolandoMySQLDBA
Aug 4, 2011 at 18:34
Thanks Rolando :-). Means a lot coming from a DBA with your experience.
– Marian
Aug 4, 2011 at 18:41

Add a comment |

1 Answer 1