how to: minutes to hours conversion
-
I found this piece of PL/SQL code in application exporting data into financial system. field_number is value of field type number (precision = 2)
trunc(field_number / 60, 0) || ',' || round(100 * (field_number / 60 - trunc(field_number / 60, 0)), 2)
ok, the code is pretty subtle but.. for example: what will be the result for field_number = 10 [min]. Let me guess, 0,16,67 ?
-
I found this piece of PL/SQL code in application exporting data into financial system. field_number is value of field type number (precision = 2)
trunc(field_number / 60, 0) || ',' || round(100 * (field_number / 60 - trunc(field_number / 60, 0)), 2)
ok, the code is pretty subtle but.. for example: what will be the result for field_number = 10 [min]. Let me guess, 0,16,67 ?
I would, sadly enough, not be surprised if the financial system wants the data in this format...
-
I found this piece of PL/SQL code in application exporting data into financial system. field_number is value of field type number (precision = 2)
trunc(field_number / 60, 0) || ',' || round(100 * (field_number / 60 - trunc(field_number / 60, 0)), 2)
ok, the code is pretty subtle but.. for example: what will be the result for field_number = 10 [min]. Let me guess, 0,16,67 ?
Ouch! Your application was not set to the correct locale. It must be 0,16.67 :)