<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
DateDiff
Items 1 to 7 of 7
Work around for calculating age using the SQL Server DateDiff function
Have you ever wanted to compute age, but the results from the DATEDIFF function seemed to be wrong some of the time? This tip covers why the DATEDIFF function does not always reliably compute age.
Read more...
By
Additional Articles
2012/05/23
|
Source:
MSSQLTips.com
|
Category:
datediff
Rating:
Rate this
|
Briefcase
|
4,200 reads
Getting Age in Text or Date Difference in text format
This function returns the difference between the date in text format
Read more...
By
Anand Uchagawkar
2011/09/01
|
Source:
SQLServerCentral.com
|
Category:
age
Rating:
|
Discuss
|
Briefcase
|
942 reads
How long has passed since SQL Server service started?
Days, hours and minutes since SQL Server service was started
Read more...
By
Lars Søe Mikkelsen
2010/11/05
|
Source:
SQLServerCentral.com
|
Category:
getdate()
Rating:
|
Discuss
|
Briefcase
|
2,199 reads
Date Manipulation with DATEADD/DATEDIFF
Learn how to use Dateadd/Datediff functions to manipulate dates in this short article from Seth Phelabaum.
Read more...
By
Seth Phelabaum
2010/04/07
|
Source:
SQLServerCentral.com
|
Category:
date manipulation
Rating:
|
Discuss
|
Briefcase
|
16,798 reads
How long has passed since SQL Server service started?
Days, hours and minutes since SQL Server service was started
Read more...
By
Lars Søe Mikkelsen
2010/11/05
|
Source:
SQLServerCentral.com
|
Category:
getdate()
Rating:
|
Discuss
|
Briefcase
|
2,199 reads
Get Business Time
Compare two timestamps and return the difference in either days, hours, minutes or seconds using the 5 workday, 8 hour rule.
Read more...
By
Megan Beebe
2008/07/21
|
Source:
SQLServerCentral.com
|
Category:
datediff
Rating:
|
Discuss
|
Briefcase
|
741 reads
Count Business Days
Using a few constants and a few numeric properties found in two days, calculate the number of workdays between two days.
Read more...
By
Megan Beebe
2008/07/18
|
Source:
SQLServerCentral.com
|
Category:
datediff
Rating:
|
Discuss
|
Briefcase
|
1,436 reads
Items 1 to 7 of 7
Tags
date manipulation
(2)
age
(1)
business days
(1)
business time
(1)
dateadd
(1)
datetime
(1)
getdate()
(1)
timeliness
(1)
t-sql
(1)
work days
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
