SQL Server DATEDIFF() Function
 SQL Server Date Functions
Definition and Usage
The DATEDIFF() function returns the time between two dates.
Syntax
| DATEDIFF(datepart,startdate,enddate) |
Where startdate and enddate are valid date expressions and 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
Now we want to get the number of days between two dates.
We use the following SELECT statement:
| SELECT DATEDIFF(day,'2008-06-05','2008-08-05') AS DiffDate |
Result:
Example
Now we want to get the number of days between two dates (notice that the
second date is "earlier" than the first date, and will result in a negative
number).
We use the following SELECT statement:
| SELECT DATEDIFF(day,'2008-08-05','2008-06-05') AS DiffDate |
Result:
SQL Server Date Functions
Need an easy way to get data into XML, or transform XML to another format?
MapForce lets you map XML data to/from any combination of XML, database, flat file, Excel 2007, XBRL, or Web services data.
Then it transforms data instantly or auto-generates royalty-free data integration code for recurrent conversions.
Download a free, fully functional 30-day trial to experience the following features:
- Easy-to-use, graphical data mapping interface
- Instant data transformation
- XSLT 1.0/2.0 and XQuery code generation
- Java, C#, and C++ code generation
- Advanced data processing functions
- Support for all major relational databases including SQL Server, IBM DB2, Oracle, and more
- Visual Studio & Eclipse integration
Download a fully-functional trial today!
|
|
|
|
