Express timediff as tenth of an hour

Vote count:

0

Would like to add a record with the difference between two date/times expressed as tenths of an hour

e.g Start 2014-06-19 15:30:00 End 2014-06-19 18:00:00 Result 2.5

so far have

   SELECT 
   LEFT(
       (REPLACE(
           TIMEDIFF('2014-06-19 18:00:00','2014-06-19 15:30:00')
       ,':','.')
    ),5
    )/6

Which gives result 0.383 = not correct, any ideas welcome TQ

asked 1 min ago

zima10101

34