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.
Many thanks for your help
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)
Many thanks for your help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER