How to substract with Sysdate ?
I have a table in SQL Server in which there is a column LastLoginDate data type Datetime . I would like to substract LastLoginDate with sysdate.
Lst Loin Date SysDate
(7/20/2012 7:01:48 AM)-(8/07/2012 7:01:48 AM)
I would like to claculate only number of days.
Please help me.