FriendlyDateDiff
One function which is often requested from my archived blog posts is dbo.FriendlyDateDiff.
The Function takes two DateTimes and a requested biggest Dimension like days / hours etc.
A sample would be calculating the datediff between My birthdate and the current date:
@Startdate = '19780619 15:15:00',
@EndDate = '20081103 19:33:16',
@BiggestDimension = {PlaceTheDimensionHere}
(Should be something around thirty years ;-) )
| Dimension | Output |
| Y | 30 years, 9 months, 25 days, 4:18:16 |
| M | 369 months, 25 days, 4:18:16 |
| D | 11095 days, 4:18:16 |
| Unknown dimension | 266284:18:16 |
Always impressive if you suprise your wife using your wedding day as a starting date and the current date as the end date, using the 'Y' parameter value :-)
The function is as an attachment with this post. Feel free to use and distribute it.
-Jens