datediff (today - date)

Hello

I want to return the number of days between a date in the database and today

something like

SELECT user.fName,
user.lName & " (" & (datediff(now - user.lastVisit)) & " )"
FROM user


I must return

John Turner (38)

where 38 are the days between last visit and now

thank yousee this,now I think you can do it easily

declare @.datevar datetime
select @.datevar = getdate()


*Example for datediff : getting no of days passed since 01-01-2006*/

select datediff(dd,'20060101',@.datevar) [No of days since 01-01-2006]|||it works !

thanks a lot