-- DATE ONLY ELEMENT
SELECT DATEADD(dd, 0,DATEDIFF(dd, 0, GETDATE()))
-- DATE TO NEAREST MINUTE
SELECT DATEADD(mi, DATEDIFF(mi, 0, GETDATE()),0)
-- CONVERT TO TIME as Varchar
SELECT CONVERT(VARCHAR(5), GETDATE(), 108)
-- SECONDS ONLY --
SELECT RIGHT(CONVERT(VARCHAR(8), GETDATE(), 108),2)
Created
February 12, 2013 16:43
-
-
Save MRdNk/4771220 to your computer and use it in GitHub Desktop.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment