SQL script to implement FUNCTIONS

[blackbirdMIT]

Can you please give me some tips to...
create an SQL script that implements three functions: MonthsUntil, DaysUntil, and HoursUntil.

wherein I can input date value
then the functions will return the number of months until the date, days until the date, or hours until the date as appropriate.

 

[TheBugSlayer]

The DateDiff function is all you need.

Syntax is DATEDIFF ( datepart , startdate , enddate ).

Example:

select DATEDIFF ( "month" , '09/11/2001' , getdate()) -- 24
select DATEDIFF ( "day" , '09/11/2001' , getdate()) -- 723
select DATEDIFF ( "hour" , '09/11/2001' , getdate()) -- 17366

 

[blackbirdMIT]

Is that the straight forward of calling the function and assigning the parameters?