Format Clock Entry#
Functionality:#
This function retrieves information as seen on IEAS, for an employee's distribution information. This is useful when translating for display purposesParameters:#
TIME | The time field, which is expressed in number of minutes since midnight |
TYPE | Optional. Identifies the type of format that you can have the time displayed in |
TYPE Parameter Values#
0 | (Default if not provided). Time is displayed as AM/PM with a separator (e.g. 2:30 PM) with no leading blank if less than 10:00 |
1 | 24-hour. Time is displayed as four digit 24-hour time with no separator (e.g. 1430) |
2 | 24-hour. Time is displayed as 24-hour time with a separator (e.g. 14:30) |
3 | European. Time is display as 24-hour time with a separator (e.g. 14h30) |
Returns: #
Varchar2Errors: #
NoneExample: #
P2K_PU.CLOCK(1276) Will return the time formatted as 9:16 PM
This may be useful when designing a workflow email message and you want to format the time from the database, like CLASS_START_TIME, as time fields are stored as minutes since midnight.