Tuesday, March 17, 2020

How to search particular date records in sql sqerver

select * from tableName where CONVERT(varchar,[Timestamp],3) = '17/03/20' //here timestamp your table column name and data type datetime.