-- EXEC [TestReport] '2019-04-08', '2019-04-08' ALTER PROCEDURE [dbo].[TestReport] @FromDate datetime, @ToDate datetime AS BEGIN select * from test where CONVERT(date,settlementDate) between CONVERT(date,@FromDate) and CONVERT(date,@ToDate) END
date
datetime
CONVERT
settlementDate
datetime2
WHERE settlementDate >= @FromDate And settlementDate < DateAdd(day, 1, @ToDate)
datetimeoffset
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)