PL/SQL API jcs.oracle_tstamp_format
Summary
Given an input format stored for a timestamp script parameter, gives the Oracle date format representing that date format.
The input format for timestamps as stored can be an Oracle format (for instance DD.MM.YYYY) or one of the following keywords: DATE, TIMESTAMP, TIME.
The keywords are used to instruct clients to follow their "default" format. For instance, the Redwood Explorer will use the "windows short date" format when DATE is specified.
This is then sent to the repository with JCS.PARAMETER(). To see how the kernel represents these dates internally, you can ask for the data representation using this function.
- For
it will return the Oracle NLS date format - For 'DATE' it will return 'SYYYYMMDD'
- For 'TIME' it will return 'HH24MISS'
- For 'DATETIME' or '--DATE_INPUT_FORMAT--' it will return 'SYYYYMMDDHH24MISS'
- For '--TSTAMP_INPUT_FORMAT--' it will return 'SYYYYMMDDHH24MISSFF TZR TZD'
- For any other input it will return the format as is
Specification
function oracle_tstamp_format(input_format in varchar2)
return varchar2
Parameters
- input_format - the input format that needs to be expanded
- returns varchar2 -
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