Posted on 2005-04-26
Good morning expert,
Have learned a lot about doing complex queries and subqueries
but having some difficulty doing simple queries on columns with
datatime data type. For instance
WHERE (dt_created LIKE '%2005%')
works (after complaining "entry cannot being
converted to a valid datetime value")
WHERE (dt_created LIKE '%24/2005%') works
returns nothing although I know there is
a date like 04/24/2005 exists in the column.
Am i making a syntactical error?
Have searched in several books and on
the 'net for info on queries on datetime
columns with no success. Is there
any knowledge base on these queiries?
Allen in Dallas