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.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Difference in days

Author  Topic 

DarkSiders
Starting Member

1 Post

Posted - 2015-01-09 : 09:18:37
Hi All

I 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)
Go to Top of Page
   

- Advertisement -