PL/SQL API jcs.oracle_date_format
Summary
Given an input format stored for a date script parameter, gives the Oracle date format representing that date format.
The input format for dates 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 any other input it will return the format as is
Specification
function oracle_date_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