get dates
what's the best way to meet the following?
end date is now - 6hrs
start date is end date - 48hrs
Does this seem right?
declare @startDate as datetime
declare @endDate as datetime
Set @endDate = dateadd(hh,-6,getdate())
Set @startDate = dateadd(hh,-48,@endDate)
end date is now - 6hrs
start date is end date - 48hrs
Does this seem right?
declare @startDate as datetime
declare @endDate as datetime
Set @endDate = dateadd(hh,-6,getdate())
Set @startDate = dateadd(hh,-48,@endDate)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER