SQL Server DATEADD() Function
 SQL Server Date Functions
Definition and Usage
The DATEADD() function is adds or subtracts a specified time interval from a date.
Syntax
| DATEADD(datepart,number,date) |
Where date is a valid date expression and number is the number of interval
you want to add. The number can either be positive, for dates in the future, or
negative, for dates in the past.
datepart can be one of the following:
| datepart | Abbreviation |
|---|
| year | yy, yyyy |
| quarter | qq, q |
| month | mm, m |
| dayofyear | dy, y |
| day | dd, d |
| week | wk, ww |
| weekday | dw, w |
| hour | hh |
| minute | mi, n |
| second | ss, s |
| millisecond | ms |
| microsecond | mcs |
| nanosecond | ns |
Example
Assume we have the following "Orders" table:
| OrderId |
ProductName |
OrderDate |
| 1 |
Jarlsberg Cheese |
2008-11-11 13:23:44.657 |
Now we want to add 45 days to the "OrderDate", to find the payment date.
We use the following SELECT statement:
SELECT OrderId,DATEADD(day,45,OrderDate) AS OrderPayDate
FROM Orders |
Result:
| OrderId | OrderPayDate |
|---|
| 1 | 2008-12-26 13:23:44.657 |
SQL Server Date Functions
Create a free Flash website with our simple, online web design editing platform. Stunning templates
and user-friendly tools make website building easy and fun.
Start Creating your free website now!
Whether you're new to XML or already an advanced user, the user-friendly views and powerful entry helpers, wizards, and debuggers in XMLSpy are designed to meet your XML and Web development needs from start to finish.
New features in Version 2010!
- XML editor
- Graphical XML Schema / DTD editors
- XSLT 1.0/2.0 editor, debugger, profiler
- XQuery editor, debugger, profiler
- XBRL validator, taxonomy editor, taxonomy wizard
- Support for Office Open XML (OOXML)
- Graphical WSDL 1.1/2.0 editor & SOAP debugger
- JSON editing & conversion
- Java, C#, C++ code generation
- 32-bit and 64-bit versions
- And much more!
Download a free trial today!
|
|
|
|
