<div>
SELECT <br />
&nbsp; &nbsp; FLOOR(DATEDIFF(DAY, customeremploymentstartdat<wbr />e, GETDATE()) / 30.412 / 12) AS employment_years , <br />
&nbsp; &nbsp; FLOOR(DATEDIFF(DAY, customeremploymentstartdat<wbr />e, GETDATE()) / 30.412 % 12) AS employment_months,<br />
&nbsp; &nbsp; *<br />
FROM tblcustomer
</div>


SELECT
    FLOOR(DATEDIFF(DAY, customeremploymentstartdate, GETDATE()) / 30.412 / 12) AS employment_years ,
    FLOOR(DATEDIFF(DAY, customeremploymentstartdate, GETDATE()) / 30.412 % 12) AS employment_months,
    *
FROM tblcustomer

tanj1035

<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
How to calculate &nbsp;the length of the employment and display it in a format like 1 years 8 months. &nbsp;[customeremployementstartd<wbr />ate]<br />
<br />
The query will be something like <br />

<pre><code id="code-10-29109560-1"></code></pre>
select getdate()- customeremploymentstartdat<wbr />e as length of the employment <br />
from tblcustomers<br />

<pre><code id="code-10-29109560-2"></code></pre>
[customeremployementstartd<wbr />ate] is in a format like 2012-12-13 09:00:00.000<br />
<br />
<br />
Thank you very much
</div>
</div>


Hi, 

How to calculate  the length of the employment and display it in a format like 1 years 8 months.  [customeremployementstartdate]

The query will be something like 
(CODE)select getdate()- customeremploymentstartdate as length of the employment 
from tblcustomers
(CODE)
[customeremployementstartdate] is in a format like 2012-12-13 09:00:00.000


Thank you very much

how to calculate the date range and display it in years+months

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.