I receive reports in which the data is ETL
to the DB automatically. I extract and transform some of that data to load it somewhere else. One thing I need to do is a DATEDIFF
but the year needs to be exact (i.e., 4.6 years instead of rounding up to five years.
The following is my script:
select *, DATEDIFF (yy, Begin_date, GETDATE()) AS 'Age in Years'
from Report_Stage;
The 'Age_In_Years'
column is being rounded. How do I get the exact date in years?