Link to home
Start Free TrialLog in
Avatar of MBoy
MBoy

asked on

SQL TimeSpan to Integer

I need this done correctly.

DECLARE @NextDate As DateTime
DECLARE @DaysLeft As Integer
SET @DaysLeft = (@NextDate - GETDATE())
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MBoy
MBoy

ASKER

I was feeling lazy today ;)