Link to home
Start Free TrialLog in
Avatar of Lightwalker
Lightwalker

asked on

Mysql SELECT all items in a particular month

Dear Experts,

This is so simple and yet I can not find out how to do it. I have a Date field in an order table and I would like to only select the orders from April of this year (2012). my Date field is in a timestamp format

How can I do that. All I have tried has not worked.

SELECT Date, 
	DetailItemID, 	
FROM order WHERE  Date = MONTH(04) 

Open in new window


Many thanks for your help
ASKER CERTIFIED SOLUTION
Avatar of johanntagle
johanntagle
Flag of Philippines image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Lightwalker
Lightwalker

ASKER

Your a star, so simple, thank you