P 2 K_PU.CLOCK

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 purposes

Parameters:#

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: #

Varchar2

Errors: #

None

Example: #

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.


Notes#

Click to create a new notes page