date functions in sql.....

Declare @Date datetime set @Date = (SELECT GETDATE());print
-- Adding 5 days with Current Date @Date -- Print Current DateSELECT

DATEADD(month, 5,@Date ) AS NewTime-- Get Only YearSELECT DATEPART(year, GETDATE()) AS 'Year'-- Get Only MonthSELECT DATEPART(month, GETDATE()) AS 'Month'-- Get Only hourSELECT
DATEPART(hour, GETDATE()) AS 'Hour'-- Declare Two DateTime VariableDeclare @Date1 datetime Declare @Date2 datetime -- Set @Date1 with Current Dateset @Date1 = (SELECT GETDATE());-- Set @Date2 with 5 days more than @Date1set @Date2 = (SELECT DATEADD(day, 5,@Date1 ))-- Get The Date DifferenceSELECT


DATEDIFF(day, @Date1, @Date2) AS DifferenceOfDay-- Get Today SELECT DATENAME(dw, getdate()) AS 'Today Is'-- Get Mont nameSELECT




DATENAME(month, getdate()) AS 'Month'SELECT
 DAY-----------15MONTH()SELECT
MONTH(getdate()) AS 'Month' Month-----------8YEAR()SELECT YEAR(getdate()) AS 'Year' DAY(getdate()) AS 'DAY'