datepart month and year sql code example Example: get hour from date sql SELECT DATEPART(HOUR, GETDATE());