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.
FROM order WHERE Date = MONTH(04)
Many thanks for your help