Hi folks,
I need to convert a gap number to a clock format.
i.e:
SQL> select value from t_regional_settings
2 where name ='GMT_GAP';
VALUE
-------------------------------------------------------
-3
I need to take this value and convert it to : - 03:00
-5 ==> - 05:30
+12 ==> + 12:00
etc ...
How to do it?
Thanks in advane.
Nir