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