sql function for difference between given date and current date code example

Example: sql get number of days between two dates

DATEDIFF(DAY, '1/1/2011', '3/1/2011')