I am using MSSQL 2005
I want no of days passed from the given date for example
If getdate() = 6 Nov
and pastDate = '2008-10-03 00:00:00.000'
Then I want no of days passed in integer
I am writting below query which is giving me date. But I want integer value, which tell no of days passed
select getDate()- CONVERT(datetime, '2008-10-03 00:00:00.000')
Thanks in Advance