I have table USERLOCK
1 2014-10-06 15:01:25.170
In my sql i need to return Lockedtime as 2014-10-07 15:01:25.170 (2014-10-06 15:01:25.170 + 24 hours )
select ID, Lockedtime+24 from USERLOCK
doesnt seem to work , it increments by 24 days
any clue how i can increment the time by 24 hours?