troubleshooting Question

finding difference between dates

Avatar of kdeutsch
kdeutschFlag for United States of America asked on
SQL
3 Comments1 Solution297 ViewsLast Modified:
What I am trying to do is take todays date and find the difference in years from another date, I don't want it to round, so if its 6.5, 6.2, 6.7, 6.8 it woould all be 6 years.  i thought about using the  GetDate function but don't know how to use the syntax or even if thats what to use.  Thanks

Select      m.dtStartDate,
            m.dtEnddate,
            p.strSSN,
            s.sidstrNAME_IND,
            s.sidstrGR_ABBR_CODE + '/' + s.sidstrPay_GR as Rank,
            GetDate s.siddatPEBD
from                           tblSadMission as m INNER JOIN
            tblAssignedPersonnel as p on p.strssn = p.strssn INNER JOIN
            cms.dbo.tblSidpers as s on p.strssn = s.sidstrssn_SM
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros