How to Substract with Sysdate ?

Abhishek Kumar · August 8th, 2012, 06:06 AM

I have a table in SQL Server in which there is a column LastLoginDate
Datatype Datetime . I would like to substract LastLoginDate with sysdate.

Last 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.

Ian Ryder · August 8th, 2012, 06:24 AM

You can use the datediff function to accommodate this. i.e:-

Dim NoDaysDifference As Integer = DateDiff(DateInterval.Day, LastLoginDate, Now())

Hope this helps.

Cheers

Ian

August 10th, 2012, 01:49 AM

Functions that expect date values usually accept datetime values and ignore the time part. Functions that expect time values usually accept datetime values and ignore the date part.The CURRENT_TIMESTAMP(), CURRENT_TIME(), CURRENT_DATE(), and FROM_UNIXTIME() functions return values in the connection's current time zone, which is available as the value of the time_zone system variable.
http://www.dapfor.com/en/net-suite/n...ial/data-types