Convert hours to 15 mins interval

1

Hi, I need to convert total mins into hour and min ( minutes in 15 mins increment )

cast(round(total_hours/60.0,2) as numeric(36,2)) = 8.25 (total_hours = 495/60 =8.25 )

In stead of 8.25, I need 8.15 (8 hours and 15 minutes) , how can I do this?

Thanks

2

This will round down to the nearest 15 min border:

SELECT hours, 
    CAST(hours / 60 AS varchar(3)) + '.' + CAST(hours % 60 / 15 * 15 AS varchar(2))
FROM ( VALUES(495), (212), (147) ) as hours(hours)
3

Thank you