DECLARE @dtDate datetime

SET @dtDate = getdate() - FLOOR( CAST( getdate() AS float ))

SELECT

@dtDate AS [YYYY-MM-DD HH:MM:SS.SSS]

, CAST( FLOOR( CAST( @dtDate AS float...