Subject Problems with a date field in a query
Author Xavier Solé

I have a table with a field which is a date, and now I want to make a query that returns all the rows in which the month of this field is March (for example). The date is stored in the mm/dd/yyyy format. I have tried this:

SELECT * from my_table
WHERE my_date_field LIKE '03%'

But it doesn't work (the query returns 0 rows). How can I do it?



[Non-text portions of this message have been removed]