15 Have you tried getting the difference in months instead and then calculating the years that way? For example 30 months / 12 would be 2.5 years. Edit: This SQL query contains several …

1001 10/9/2011 - 12/9/2011 2 days 1001 12/9/2011 - 20/9/2011 8 days 1001 20/9/2011 NA Basically what i would like to do is have an access query that calculates the date difference for …

Jan 22, 2010 · Is there any way to take the difference between two datetime in sql server? For example, my dates are 2010-01-22 15:29:55.090 2010-01-22 15:30:09.153 So, the result …

I have to calculate the difference in hours (decimal type) between two dates in SQL Server 2008. I couldn't find any useful technique to convert datetime to decimal with 'CONVERT' on MSDN.

Oct 15, 2009 · I have a table listing people along with their date of birth (currently a nvarchar(25)) How can I convert that to a date, and then calculate their age in years? My data looks as …

Oct 9, 2009 · How can I use DATEDIFF to return the difference between two dates in years, months and days in SQL Server 2005 DATEDIFF (date , date) How to result that: 2 year 3 …

Oct 31, 2008 · How can I calculate the number of work days between two dates in SQL Server? Monday to Friday and it must be T-SQL.

Googling "How to find the number of days between two dates query" found multitudes of answers. That's what you should try first.

I've got 2 date columns in my table (start_date, end_date). I've tried Datediff(day, start_date, end_date), but I was prompt with: invalid column name How can I calculate the date difference …

The DateDiff function returns how many seconds, months, years - whatever interval you specify between the first date (here 0) and the second date (here the current date).