To perform calculations via sql server

For days SELECT DATEDIFF(DAY,'2024-11-01','2024-11-28') AS days_difference;

For months SELECT DATEDIFF(MONTH,'2024-11-01','2024-11-28') AS months_difference;

For years For days SELECT DATEDIFF(YEAR,'2024-11-01','2024-11-28') AS years_difference;