dateadd and datediff function in SQL server 2019 in (2020)

Published: 06 June 2020
on channel: Learn Tech with Ashish

This video is for dateadd and datediff function in SQL server

dateadd function can be used to add any interval like Day, Month, Year, etc.
Example:- i want to add 2 Months in todays date
select DateAdd(month,2,Getdate())

DateDiff function is used to get the difference between two dates in specific boundaries like Day, Month, Year, etc.

Example:- i want to get diffrenct between 06-06-2020 and 07-06-2020 in Months in
select DateAdd(month,'2020-06-06','2020-07-06')

great tutorial to learn SQL Server and T-SQL with Examples and new videos in simple language

On this page of the site you can watch the video online dateadd and datediff function in SQL server 2019 in (2020) with a duration of hours minute second in good quality, which was uploaded by the user Learn Tech with Ashish 06 June 2020, share the link with friends and acquaintances, this video has already been watched 77 times on youtube and it was liked by 1 viewers. Enjoy your viewing!