Skip to content

ErcanOPAK.com

  • ASP.Net WebForms
  • ASP.Net MVC
  • C#
  • SQL
  • MySQL
  • PHP
  • Devexpress
  • Reportviewer
  • About
SQL

DATEADD Function in SQL

- 14.06.18 | 22.11.19 - ErcanOPAK

DATEADD(interval, number, date)

Parameter Values (interval, number, date)

Parameter Description
interval Required. The time/date part to return. Can be one of the following values:

  • year, yyyy, yy = Year
  • quarter, qq, q = Quarter
  • month, mm, m = month
  • dayofyear = Day of the year
  • day, dy, y = Day
  • week, ww, wk = Week
  • weekday, dw, w = Weekday
  • hour, hh = hour
  • minute, mi, n = Minute
  • second, ss, s = Second
  • millisecond, ms = Millisecond
number Required. The number of intervals to use
date Required. The date to which the interval should be added


Examples:

-- GETDATE(): 2018-06-14 11:53:38.350

SELECT DATEADD(year, 1, GETDATE()) AS DateAdd;
-- OUTPUT:
2019-06-14 11:48:14.240


SELECT DATEADD(week, 1, GETDATE()) AS DateAdd;
-- OUTPUT:
2018-06-21 11:52:56.263

SELECT DATEADD(month, 1, GETDATE()) AS DateAdd;
-- OUTPUT:
2018-07-14 11:54:22.617

SELECT DATEADD(day, 15, GETDATE()) AS DateAdd;
-- OUTPUT:
2018-06-29 11:55:06.413

Related posts:

Search text in all stored procedures in SQL Server
Find numbers with more than two decimal places in SQL
How to use Nested Cursors in SQL
Reset the Identity on table in MSSQL
How to solve 'Size property has an invalid size of 0' in C#
Post Views: 164

Post navigation

Imitating a blink tag with CSS3 animations
How to solve WordPress “Briefly unavailable for scheduled maintenance.” problem

Leave a Reply Cancel reply

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

May 2022
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Apr    

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (331)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (220)
  • Find numbers with more than two decimal places in SQL (191)
  • How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (190)
  • Confirm before process with ASPxButton in Devexpress (189)
  • ASPxGridView – Disable CheckBox based on condition in GridViewCommandColumn (189)
  • How to make some specific word(s) Bold or Underline in ReportViewer (189)
  • Devexpress ASPxGridview Column Grouping in Code (176)
  • Add Constraint to SQL Table to ensure email contains @ (174)
  • Tense Changes When Using Reported Speech (167)

Recent Posts

  • How to put text inside MVC Razor code block
  • How to solve 0xc0000135 application errors after Windows 11 Update
  • How to get the integrity value for a jquery version of script reference in a web page
  • How to get session value in Javascript
  • How to get value from resx file in C#
  • How to lock the ciritical code part in C#
  • How to make theater mode the default for Youtube
  • How to turn off YouTube annotations and cards
  • How to hide Youtube chat windows permanently
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server

Recent Posts

  • How to put text inside MVC Razor code block
  • How to solve 0xc0000135 application errors after Windows 11 Update
  • How to get the integrity value for a jquery version of script reference in a web page
  • How to get session value in Javascript
  • How to get value from resx file in C#

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (331)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (220)
  • Find numbers with more than two decimal places in SQL (191)
  • How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (190)
  • Confirm before process with ASPxButton in Devexpress (189)

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter

powered by XBlog Plus WordPress Theme