Best Online Tutorials

SQL Tutorial

Free SQL Tutorial

SQL Interview Questions

SQL Practice Questions

SQL Tips & Tricks

SQL Errors

SQL Books

Angular Tutorial

Free Angular Tutorial

Angular Interview Questions

Angular Practice Questions

Angular Tips & Tricks

Angular Errors

Angular Books

Node.js Tutorial

Free Node.js Tutorial

Node.js Interview Questions

Node.js Practice Questions

Node.js Tips & Tricks

Node.js Errors

Node.js Books

React.js Tutorial

Free React.js Tutorial

React.js Interview Questions

React.js Practice Questions

React.js Tips & Tricks

React.js Errors

React.js Books

SSIS Tutorial

Free SSIS Tutorial

SSIS Interview Questions

SSIS Practice Questions

SSIS Tips & Tricks

SSIS Errors

SSIS Books

SEO Tutorial

Free SEO Tutorial

SEO Interview Questions

SEO Practice Questions

SEO Tips & Tricks

SEO Errors

SEO Books

Javascript Tutorial

Free Javascript Tutorial

Javascript Interview Questions

Javascript Practice Questions

Javascript Tips & Tricks

Javascript Errors

Javascript Books

MongoDB Tutorial

Free MongoDB Tutorial

MongoDB Interview Questions

MongoDB Practice Questions

MongoDB Tips & Tricks

MongoDB Errors

MongoDB Books

Next.js Tutorial

Free Next.js Tutorial

Next.js Interview Questions

Next.js Practice Questions

Next.js Tips & Tricks

Next.js Errors

Next.js Books

Error Messages (Msg 155): '<Option>' is not a recognized DATEADD option. 

Pooja Goel  |   Dec 15, 2019  |  Views: 145
pictures

Description:

Lets suppose You have executed the given queries to use “DATEADD” function in SQL SERVER 2014.

 

Here are few Examples :


 
SELECT Dateadd(YR, 10,GETDATE())
SELECT Dateadd(Hr, 10,GETDATE())
SELECT Dateadd(Se, 10,GETDATE())
SELECT Dateadd(days, 10,GETDATE())
SELECT
Dateadd(mon, 10,GETDATE())
 


Error Message :

But getting the below errors. 


Msg 155, Level 15, State 1, Line 2
'YR' is not a recognized dateadd option.
Msg 155, Level 15, State 1, Line 3
'Hr' is not a recognized dateadd option.
Msg 155, Level 15, State 1, Line 4
'Se' is not a recognized dateadd option.
Msg 155, Level 15, State 1, Line 5
'days' is not a recognized dateadd option.
Msg 155, Level 15, State 1, Line 6
'mon' is not a recognized dateadd option.


Causes:

If you are trying to call DATEADD function by using wrong interval for date, above mentioned errors occur.

 

Solution of the Error:

Use valid interval for Specified date when you are calling DATEADD function. There are following list of valid Interval for date.

 

  • 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

Here are correct ways to call DATEADD function in SQL Server.

 

 
SELECT Dateadd(Year, 10,GETDATE())
SELECT Dateadd(Hour, 10,GETDATE())
SELECT Dateadd(Second, 10,GETDATE())
SELECT Dateadd(day, 10,GETDATE())
SELECT
Dateadd(MONTH, 10,GETDATE())

 

Output :


2029-12-15 16:14:23.623
2019-12-16 02:14:23.623
2019-12-15 16:14:33.623
2019-12-25 16:14:23.623
2020-10-15 16:14:23.623

 


Comments:
Content Contributor
Pooja Goel

Pooja Goel

Sr. Software developer at Damco Solutions Pvt. Ltd.  |   Noida, Uttar Pradesh, India

I am a sr. software developer working on technologies like SQL, SSIS, SSRS, DB2,Tableau, ASP.NET having 7 years of experience.


Read related articles

Want to sell your software ?-

If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.

  • Sell ERP
  • Sell Website Clones
  • Sell App Clones
  • Sell Readymade Portals
  • Sell Readymade Websites
  • Sell Mobile Apps
  • Sell Window Apps

Clients will find it using our advanced search filter and will contact you directly.

No any charge for the product lsiting.

Do you own a Company ?+

Property.sale

Buy or Sell Commercial Property+

Are you a freelancer ?+

Looking for a job ?+

Are you a Service Provider ?+

Are you a blogger ?+

Do you own an IT Institute ?+



Property.sale