Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DarkSiders
Starting Member
1 Post |
 Posted - 2015-01-09 : 09:18:37
|
| Hi AllI need a help from you guys.I want to calculate the difference in days between the most an the least tenured employee still working in the company. I have the Hire Date and the termination date, First Name, last name and Employer ID.Can anyone please help? |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-01-09 : 09:28:31
|
| datediff(day, HireDate, TerminationDate) |
 |
|
|
|
|
|
Difference in days