date difference

[ravi]

Hi I wanted to get difference between this two dates '12-31-2001','01-01-2002').
1 day 0 month 0 year.
Do we have any date function to get like this or we need write our own function stored proc?>
Any advice please?.

[MAK]

you have to do something similar to this thread

http://forums.databasejournal.com/sh...threadid=32960