DW_logo

OBIEE
Custom Format Strings for Conversion into Hours, Minutes and Seconds


     Follow the below mentioned steps for custom formatting.
  1. Select Column Properties
  2. Then in the Data Format Tab, select Treat Numbers as Custom. Then write the data Conversion Format String.
OBIEE_CustomTimeFormat


Data Conversion
Format String
Result
  [duration(sec)][opt:dd]:hh:mm:ss
Formats the total of seconds as duration. For example, a duration value of 16500.00 is displayed as 04:35:00, meaning a duration of four hours, 35 minutes, and zero seconds.opt:dd displays the number of days, but if opt has no value, it is not displayed. Second is the default unit of time.
  [duration(min)][opt:dd]:hh:mm:ss

Formats the total of minutes as duration. For example, a duration value of 275.00 is displayed as 04:35:00, meaning a duration of four hours, 35 minutes, and zero seconds. opt:dd displays the number of days, but if opt has no value, it is not displayed
  [duration(hour)][opt:dd]:hh:mm:ss

Formats the total of hours as duration. For example, a duration value of 4.58 is displayed as 04:35:00, meaning a duration of four hours, 34 minutes, and 48 seconds. opt:dd displays the number of days, but if opt has no value, it is not displayed.
  [duration(day)][opt:dd]:hh:mm:ss

Formats the total of days as duration. For example, a duration value of 2.13 is displayed as 02:03:07:12, meaning a duration of two days, three hours, seven minutes, and twelve seconds. opt:dd displays the number of days, but if opt has no value, it is not displayed.


I recreated this web page to make sure it does not go away. Very useful ! Special Thanks





FluidBlocks_Icon32
Designed with Fluid Blocks