authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_format_date_path
Parameters
Name
Type
Mode
template
text
IN
d
date
IN
Definition
SELECT replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace( replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace( template, '{YYYY}', to_char(d, 'YYYY')), '{YY}', to_char(d, 'YY')), '{MM}', to_char(d, 'MM')), '{DD}', to_char(d, 'DD')), '{Mmmm}', to_char(d, 'FMMonth')), '{MMMM}', upper(to_char(d, 'FMMonth'))), '{FMMonth}', to_char(d, 'FMMonth')), '{Mmm}', to_char(d, 'Mon')), '{MMM}', to_char(d, 'MON')), '{Ddd}', to_char(d, 'Dy')), '{DDD}', to_char(d, 'DY')), '{date}', to_char(d, 'YYYYMMDD')), '{DATE}', to_char(d, 'YYYYMMDD')), '<YYYY>', to_char(d, 'YYYY')), '<YY>', to_char(d, 'YY')), '<MM>', to_char(d, 'MM')), '<DD>', to_char(d, 'DD')), '<Mmmm>', to_char(d, 'FMMonth')), '<MMMM>', upper(to_char(d, 'FMMonth'))), '<FMMonth>', to_char(d, 'FMMonth')), '<Mmm>', to_char(d, 'Mon')), '<MMM>', to_char(d, 'MON')), '<Ddd>', to_char(d, 'Dy')), '<DDD>', to_char(d, 'DY')), '<date>', to_char(d, 'YYYYMMDD')), '<DATE>', to_char(d, 'YYYYMMDD'))