DeepTechSupport : Step By Step SQL Server Lesson 9 DateAdd Function
Channel : DeepTechSupport :
Step By Step SQL Server Lesson 9 DateAdd Function
----------------------------------
Date in SQL Server
------------------------------------
select getdate()
------------------------------------
select Convert(Varchar(11), getdate(),106)
------------------------------------
select Replace(Convert(Varchar(11), getdate(),106),' ' ,'-')
------------------------------------
select Convert(Varchar(8), getdate(),108) as CurrentTime
------------------------------------
select dateadd(HOUR, 2, getdate()) as AddedDateTime, getdate() as CurrentDateTime
------------------------------------
select dateadd(HH, 2, getdate()) as AddedDateTime, getdate() as CurrentDateTime
------------------------------------
select dateadd(MINUTE , 20, getdate()) as AddedDateTime, getdate() as CurrentDateTime
------------------------------------
select dateadd(MI , 20, getdate()) as AddedDateTime, getdate() as CurrentDateTime
------------------------------------
select dateadd(SECOND , 60, getdate()) as AddedDateTime, getdate() as CurrentDateTime
------------------------------------
select dateadd(SS , 60, getdate()) as AddedDateTime, getdate() as CurrentDateTime
------------------------------------
select dateadd(MILLISECOND, 20, getdate()) as AddedDateTime, getdate() as CurrentDateTime
------------------------------------
select dateadd(MI, 20, getdate()) as AddedDateTime, getdate() as CurrentDateTime
------------------------------------
select dateadd(YEAR, 20, getdate()) as AddedDateTime, getdate() as CurrentDateTime
------------------------------------
select dateadd(month, 12, getdate()) as AddedDateTime, getdate() as CurrentDateTime
------------------------------------
select dateadd(MM, 12, getdate()) as AddedDateTime, getdate() as CurrentDateTime
------------------------------------
select dateadd(DAY, 5, getdate()) as AddedDateTime, getdate() as CurrentDateTime
------------------------------------
select dateadd(WEEKDAY, 5, getdate()) as AddedDateTime, getdate() as CurrentDateTime
------------------------------------
select dateadd(WEEK , 1, getdate()) as AddedDateTime, getdate() as CurrentDateTime
--------------------------------------------
For More Detail Please Visit Our Site
http://tech.deeptechsupport.com/2018/...