Saturday , December 9 2023

DATEADD Function in SQL Server(TSQL)


With the DATEADD function we can add or remove a datepart to a date. Below is a list of the dateparts we can add.

The DATEADD Function is one of the most used date functions.

yearyy, yyyy
quarterqq, q
monthmm, m
dayofyeardy, y
daydd, d
weekwk, ww
weekdaydw, w
minutemi, n
secondss, s

Let’s make examples for a better understanding of DATEADD Function.

Add year to a date using DATEADD Function:

Add week to a date using DATEADD Function:

You can use DATEADD function as follows:

Remove week from a date using DATEADD Function:


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *