mssql datetime

[Anon]

I would like to search for dates in column with a datetime-type. I use this line;

$result= mssql_query("SELECT * FROM LOG WHERE $find LIKE '%" . $indata . "%' ORDER BY $sort",$con);

1. How do I search for 2001-05-14? It just returns results when I search for 2001. Another thing which may cause the problem is that it displays the results in 14th of May 2001 and so on. In the fields you find 2001-05-14 16:32:01 just like I inserted it. How do I display that without the original, "long" description?

Thanks / Henrik

[fleymingmasc]

Try a different tack when dealing with dates:

SELECT * FROM LOG WHERE datefield BETWEEN $date AND DATEADD(d, 1, $date) ORDER BY $sort

IIRC, LIKE should only be used on character data. You may be invoking an implicit CAST to a character type when you use LIKE on a date. (I guess when MSSQL CASTs a date to a string, it uses a locale-based format, which would possibly explain why you're getting 14th of May etc.)