Getting the date from SQL without the time is easy

DECLARE @Today DATETIME = CONVERT(DATE,GETDATE())

DECLARE @EndOfToday DATETIME
set @EndOfToday = DATEADD(MS
                         , -1
                         ,DATEADD(D, 1, CONVERT(DATETIME2, CONVERT(DATE,GETDATE()))))