Question:
Hi,
Is there any function module wherein the accumulated mins for example 269 to be converted in a time format. which will have the output like 04:29:00 ---> 4 hrs and 29 mins..
Thanks for your help.
Answer:
No, but it shouldn't be difficult to write one eg:
w_hours = FLOOR( w_start_mins / 60 ).
w_mins = w_start_mins MOD 60.
Extended of course to include days and of course with the hardcoded 60 replaced by a variable held in a table, in case someone decides sometime in the future that there should be more / less than 60 minutes in an hour.
Answer:
If you add a number to a type T, the number will be interpreted as seconds.
Likewise, if you add a number to a type D, the number is interpreted as days.
Of course, you need to watch out for wraparounds.
Re christmaslights' sarcastic comment - I'll point out that there's a big difference between the situation he mentioned and the actual fact that some countries use different decimal and thousand separators.
I wonder ... are Greenpeace based in Hampshire?
http://society.guardian.co.uk/voluntary/story/0,7890,1675312,00.html
_________________
First he pinches my sig, Now he's cribbing my posts too!
Answer:
Just trying to cover myself. Can't win can I. And I am NOT a he.