>Hello Dear Friends
>
>I do need to format a date diff in follow pattern 'HH:MM', someone can help me?
>
>thanks
When you execute a SELECT command that subtracts one date from another, Oracle will return decimal hours (e.g., 1.1234). You can take the decimal portion of that result and multiply it by 60 to get the minutes, then concatenate that value to the hours portion of the return value.
Mark McCasland
Midlothian, TX USA