Q&A for community managers, administrators, and moderators
--Date Only SELECT CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, GETDATE()))) --Time Only SELECT LTRIM(RIGHT(CONVERT(VARCHAR(20), GETDATE(), 100), 7))