SELECT custid, datetoday FROM customers WHERE (CONVERT(VARCHAR, datetoday, 101) LIKE '5/13/2014%')
Quote:I want to see the records for today only.
SELECT custid, datetoday FROM customers where Cast(DATEDIFF(dd, datetoday, getDate()) as int) =0
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)