Click here to Skip to main content
15,891,184 members

where condition for select date

Revision 1
I have a table "DOB",
Which have two columns "Name" and "dateOfBirth",
now i want calculate total rows(result) which have
1. jan month,2012 year,
2. feb month,2012 year,
etc,

so how i use where condition, in the same column name "dateOfBirh" ,
which is in date time formet,
like 12/7/2012 12:24:00:PM,



I tried like this:
where dateOfBirh=/1/2012,
Posted 28-Dec-12 20:31pm by Arun kumar Gauttam.
Tags: