Link to home
Get AccessLog in
Avatar of al4629740
al4629740Flag for United States of America

asked on

search dates of a specific month

I have a column that stores dates in string format called EventDate  (ie. 1/12/2012)

I have a table named tblEvents

How do I search all EventDates that are in March
Avatar of AlMounkez Consultant
AlMounkez Consultant
Flag of Syrian Arab Republic image

try select * from tblEvents where month(EventDates) =3
Avatar of al4629740

ASKER

Can I do it by the name of the month instead of the number
ASKER CERTIFIED SOLUTION
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
SOLUTION
Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access