Date to String in SQL statement

Hi,



I have to be able to execute an sql statement which would look something like this.



SELECT *

FROM Table1

WHERE start_date LIKE '*01*'



The problem is this does not work since start_date is from the type date.



How can I convert the start_date field to a string in order to execute the where clause?

Hi,

This depends on what you want to do...I can't promise you these will all work since this is untested, but it's along these ideas to check out....



If you're not worried about the year:



-- e.g. For January

SELECT *

FROM MyTable

WHERE MONTH(DateField) = 1



Or, if you do need to limit to a specific year:

a)

-- e.g. for January 2003

SELECT *

FROM MyTable

WHERE MONTH(DateField) = 1 AND YEAR(DateField) = 2003



b)

-- e.g. for January 2003

SELECT *

FROM MyTable

WHERE DateDiff(m, DateField, '2003-01-01') = 0



also check out some other date functions that may help you, google around for date functions