authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_parse_date
Parameters
Name
Type
Mode
value
text
IN
include_current
boolean
IN (DEFAULT true)
date_ref
date
IN (DEFAULT CURRENT_DATE)
Definition
select case upper(value) when 'TODAY' then date_ref when 'TOMORROW' then date_ref + interval '1 day' when 'YESTERDAY' then date_ref - interval '1 day' when 'NEXT_7_DAYS' then date_ref + interval '6 day' when 'NEXT_30_DAYS' then date_ref + interval '29 day' when 'LAST_30_DAYS' then date_ref - interval '29 day' when 'NEXT_MONTH' then date_trunc('month', date_ref) - interval '1 month' when 'LAST_MONTH' then date_trunc('month', date_ref) - interval '1 day' when 'START_OF_MONTH' then date_trunc('month', date_ref) when 'END_OF_MONTH' then date_trunc('month', date_ref) + interval '1 month - 1 day' when 'START_OF_YEAR' then date_trunc('year' , date_ref) when 'END_OF_YEAR' then date_trunc('year' , date_ref) + interval '1 year - 1 day' else value::date end::date