PL/SQL API jcs.ts_sort

Summary

• function ts_sort(ts_in in date, tz_in in varchar2) return number
• function ts_sort(ts_in in timestamp, tz_in in varchar2) return number
• function ts_sort(ts_in in timestamp with time zone) return number

This call can be used to convert a date value to a number value that is suited to be compared against one of the performance columns (named *_sort) in rs_jobs or rs_operator_messages.

Specification

function ts_sort(ts_in in date,
tz_in in varchar2 default null)
    return number

Parameters

• ts_in - the date to be converted
• tz_in - the timezone in which this date must be interpreted. If it is not provided the sessiontimezone is used
• returns number -

Transaction keyword

The transaction keyword defines how and/or when the changes are committed to the database. A definition of the various transaction keywords can be found on the jcs package summary page.

none

Specification

function ts_sort(ts_in in timestamp,
tz_in in varchar2 default null)
    return number

Parameters

• ts_in - the date to be converted
• tz_in - the timezone in which this date must be interpreted. If it is not provided the sessiontimezone is used
• returns number -

Transaction keyword

The transaction keyword defines how and/or when the changes are committed to the database. A definition of the various transaction keywords can be found on the jcs package summary page.

none

Specification

function ts_sort(ts_in in timestamp with time zone)
    return number

Parameters

• ts_in - the date to be converted
• returns number -

Transaction keyword

The transaction keyword defines how and/or when the changes are committed to the database. A definition of the various transaction keywords can be found on the jcs package summary page.

none

plsqlTopic

onsiteTopic