Date calculation

Hi there,

I need some professional help. Give a date in numeric format YYYYMMDD I would like to calculate the number of days between 2 given dates.
Is there a mathematical formula that can be used? Or is there a SQL converison statement that can be used? How would one do it?

Example:

20070208 Feb 8, 2007
and
20060503 May 3, 2006

a simple a - b does not give me the correct number of days.

 

Also another question:

How would you use SQL to convert from a number to date if a date was in number format like YYYYMMDD?

 

Try the datediff function. You shouldn't need to convert it.

select datediff('20070208', '20060503');