txrpt: Provide functions to convert date/time fields to a readable format (Doc ID 766142.1)

Last updated on JULY 25, 2024

Applies to:

Goal

ISSUE:  The 'txprt' utility displays starting/ending dates/times for all the advertised services, but the values that
get displayed are not of a user-friendly format.  All the numbers are a regular representation of date under UNIX -
the date fields mean seconds passed since the first January 1970, while the starting and ending time  numbers are
1/100 seconds since midnight.  Eg:

SERVICE    PID        SDATE        STIME        EDATE        ETIME
 -------    ---        -----        -----        -----        -----
BUILD      <pid#>       ...    45306109     947695385    45306787

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.