I am looking for way to convert hours to a date range via transact sql.
Assumption: The date range would always start on the 1st of the current month.
If I give a value of 48 hrs.
Then the result should be 7/1/2009 12:00:00AM - 7/2/2009 23:59:59 PM
Also, the input value of hours could also be in fractions, such as 48.15 hrs.