Select ComplaintID, Subject, CONVERT(varchar(20),RecievedDate,103) as RecievingDate from Complaints where Convert(date,RecievedDate)>= @DateFrom AND Convert(date,RecievedDate)<= @DateTo
Select ComplaintID, Subject,REPLACE(convert(varchar, RecievedDate, 106), ' ','/') as RecievingDate from Complaints where Convert(date,RecievedDate)>= @DateFrom AND Convert(date,RecievedDate)<= @DateTo
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)