Employees Table In this example, we want to find out when an employee will be eligible for retirement, after 30 years of service. Syntax DATEPART Reference Table Example Results The SQL DATEADD function can be very useful when you are interested in adding or subtracting a specific amount of time from a column or a date.
