What SQL function could be used to retrieve records based on a date difference from the current date?

• A. DATEDIFF
• B. DATEADD
• C. DATETRUNC
• D. DATEPART

Answer: (A)

The DATEDIFF function is specifically designed to calculate the difference between two date values, returning the number of specified time intervals (such as days, months, or years) between these dates. When you want to retrieve records based on a date difference from the current date, DATEDIFF allows you to compare a field that contains date values against the current date, effectively filtering records by how far in the past or future those dates are.

For example, if you want to find all records where a date is within the last 30 days, you can use DATEDIFF in your SQL query to generate that comparison by measuring the difference in days between the target date and today’s date. It's a common tool for date filtering in SQL queries, making it the appropriate choice for this scenario.

The other functions provided serve different purposes. DATEADD is used for adding a specific interval to a date, DATETRUNC truncates a date to a specified precision (like year or month), and DATEPART extracts a part of the date (such as the month or day) but does not directly compare dates for a difference. Thus, DATEDIFF stands out as the most relevant function for retrieving records based on a date difference from the current date.