Hi,
I have a requirement to populate the hours as shown in the below example.
1. If the Hour is 8.13 , which has decimal ( 8h.13mi), I need to show as 8.15 => Minutes if < 15 then minutes should be rounded as 15
2. If the hour is 8.23 , then I need to show 8.30 => Minutes < 30 then minutes should be rounded as 30
3. If the hour is 8.38 then I need to show 8.45 => Minutes < 45 then minutes should be rounded as 45
4. If the hour is 8:47 then I need to show 9h. => Minutes < 60 then minutes should be rounded as round the Hour as ( 9 hour )
Please suggest me the logic to populate the values accordingly , from the table, that might populate more records.
I need to achieve this using SQL statement.
thanks