{"id":9622,"date":"2019-02-18T08:16:22","date_gmt":"2019-02-18T08:16:22","guid":{"rendered":"https:\/\/dbtut.com\/?p=9622"},"modified":"2019-02-18T08:16:22","modified_gmt":"2019-02-18T08:16:22","slug":"dateadd-function-in-sql-servertsql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/","title":{"rendered":"DATEADD Function in SQL Server(TSQL)"},"content":{"rendered":"

 <\/p>\n

With the DATEADD function we can add or remove a datepart to a date. Below is a list of the dateparts we can add.<\/p>\n

The DATEADD Function is one of the most used date functions.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
datepart<\/td>\nAbbreviations<\/td>\n<\/tr>\n
year<\/td>\nyy,\u00a0yyyy<\/td>\n<\/tr>\n
quarter<\/td>\nqq,\u00a0q<\/td>\n<\/tr>\n
month<\/td>\nmm,\u00a0m<\/td>\n<\/tr>\n
dayofyear<\/td>\ndy,\u00a0y<\/td>\n<\/tr>\n
day<\/td>\ndd,\u00a0d<\/td>\n<\/tr>\n
week<\/td>\nwk,\u00a0ww<\/td>\n<\/tr>\n
weekday<\/td>\ndw,\u00a0w<\/td>\n<\/tr>\n
hour<\/td>\nhh<\/td>\n<\/tr>\n
minute<\/td>\nmi,\u00a0n<\/td>\n<\/tr>\n
second<\/td>\nss,\u00a0s<\/td>\n<\/tr>\n
millisecond<\/td>\nms<\/td>\n<\/tr>\n
microsecond<\/td>\nmcs<\/td>\n<\/tr>\n
nanosecond<\/td>\nns<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Let’s make examples for a better understanding of DATEADD Function.<\/p>\n

Add year to a date using DATEADD Function:<\/strong><\/p>\n

SELECT DATEADD(year,1,'2019-01-01') AS YEAR_DATEPART,\r\n       DATEADD(yy,1,'2019-01-01') AS YY_DATEPART,\r\n       DATEADD(yyyy,1,'2019-01-01') AS YYYY_DATEPART<\/pre>\n
\"\"<\/p>\n
Add week to a date using DATEADD Function:<\/strong><\/p>\n
SELECT DATEADD(wk,1,'2019-01-01') AS week_wk_DATEPART<\/pre>\n
\"\"<\/p>\n
You can use DATEADD function as follows:<\/strong><\/p>\n
DECLARE @dateaddexample datetime\r\nSET @dateaddexample='2019-01-01'\r\nSELECT DATEADD(wk,1,@dateaddexample) AS week_wk_DATEPART<\/pre>\n
\"\"<\/p>\n
Remove week from a date using DATEADD Function:<\/strong><\/p>\n
SELECT DATEADD(wk,-1,'2019-01-01') AS week_wk_DATEPART<\/pre>\n
\"\"<\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
  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. datepart Abbreviations year yy,\u00a0yyyy quarter qq,\u00a0q month mm,\u00a0m dayofyear dy,\u00a0y day dd,\u00a0d week wk,\u00a0ww weekday dw,\u00a0w hour hh minute …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3,1596],"tags":[2061,2062,2060,2056,2055,2063,2058,2059,2057],"class_list":["post-9622","post","type-post","status-publish","format-standard","","category-mssql","category-tsql","tag-add-a-day-to-a-date-using-dateadd-function","tag-add-a-month-to-a-date-using-dateadd-function","tag-add-a-week-to-a-date-using-dateadd-function","tag-dateadd","tag-dateadd-function","tag-dateadd-usage","tag-remove-a-day-from-a-date-using-dateadd","tag-remove-a-month-from-a-date-using-dateadd","tag-remove-a-week-from-a-date-using-dateadd"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":177,"today_views":0},"yoast_head":"\nDATEADD Function in SQL Server(TSQL) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"DATEADD Function in SQL Server(TSQL)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DATEADD Function in SQL Server(TSQL) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"DATEADD Function in SQL Server(TSQL)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-18T08:16:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a685b28861.png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"DATEADD Function in SQL Server(TSQL)\",\"datePublished\":\"2019-02-18T08:16:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/\"},\"wordCount\":123,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a685b28861.png\",\"keywords\":[\"Add a day to a date using DATEADD Function:\",\"Add a month to a date using DATEADD Function:\",\"Add a week to a date using DATEADD Function:\",\"DATEADD\",\"DATEADD Function\",\"DATEADD Usage\",\"Remove a day from a date using DATEADD\",\"Remove a month from a date using DATEADD\",\"Remove a week from a date using DATEADD\"],\"articleSection\":[\"MSSQL\",\"TSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/\",\"name\":\"DATEADD Function in SQL Server(TSQL) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a685b28861.png\",\"datePublished\":\"2019-02-18T08:16:22+00:00\",\"description\":\"DATEADD Function in SQL Server(TSQL)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a685b28861.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a685b28861.png\",\"width\":781,\"height\":240},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DATEADD Function in SQL Server(TSQL)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"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.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DATEADD Function in SQL Server(TSQL) - Database Tutorials","description":"DATEADD Function in SQL Server(TSQL)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/","og_locale":"en_US","og_type":"article","og_title":"DATEADD Function in SQL Server(TSQL) - Database Tutorials","og_description":"DATEADD Function in SQL Server(TSQL)","og_url":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/","og_site_name":"Database Tutorials","article_published_time":"2019-02-18T08:16:22+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a685b28861.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"DATEADD Function in SQL Server(TSQL)","datePublished":"2019-02-18T08:16:22+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/"},"wordCount":123,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a685b28861.png","keywords":["Add a day to a date using DATEADD Function:","Add a month to a date using DATEADD Function:","Add a week to a date using DATEADD Function:","DATEADD","DATEADD Function","DATEADD Usage","Remove a day from a date using DATEADD","Remove a month from a date using DATEADD","Remove a week from a date using DATEADD"],"articleSection":["MSSQL","TSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/","url":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/","name":"DATEADD Function in SQL Server(TSQL) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a685b28861.png","datePublished":"2019-02-18T08:16:22+00:00","description":"DATEADD Function in SQL Server(TSQL)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a685b28861.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c6a685b28861.png","width":781,"height":240},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/18\/dateadd-function-in-sql-servertsql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"DATEADD Function in SQL Server(TSQL)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"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.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9622","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=9622"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9622\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=9622"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=9622"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=9622"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}