How do I calculate the difference between a recorded date in SQL and current date?

Let's say, in my sql table my date is 2-12-2008.
So I want to use a function in sql that will return the different between that date and the current date.

How do I do that?