PL/SQL API jcs.get_starttime · Redwood Documentation

Summary

function get_starttime(submit_frame_partition in varchar2, submit_frame_name in varchar2, starttime in timestamp with time zone, timezone_name in varchar2, time_window_partition in varchar2, time_window_name in varchar2) return timestamp with time zone

Determine a good starttime for a job with submit frame/time window combination

For a given submitframe, and an optional starttime and timezone_name, and timewindow, determine the first time corresponding to the submitframe that is at least equal to the starttime.

Specification

function get_starttime(submit_frame_partition in varchar2,
submit_frame_name in varchar2,
starttime in timestamp with time zone default null,
timezone_name in varchar2 default null,
time_window_partition in varchar2 default null,
time_window_name in varchar2 default null)
    return timestamp with time zone

Parameters

submit_frame_partition - the partition of the submitframe
submit_frame_name - the name of the submitframe
starttime - the minimum acceptable time for the return value If starttime is not filled the current database time is used
timezone_name - the required timezone of the result If it is not filled in, the timezone of the starttime is used
time_window_partition - the partition of an optional external time window
time_window_name - the name of an optional external time window
returns timestamp with time zone -

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