GitHub

# SQL - Create Date Dimension with Fiscal Years

[DayOfMonth] VARCHAR(2), -- Field will hold day number of Month [DaySuffix] VARCHAR(4), -- Apply suffix as 1st, 2nd ,3rd etc [DayName] VARCHAR(9), -- Contains name of the day, Sunday, Monday ...
GitHub

f_create_date_partitions(text,timestamp).sql

v_ts_format text := 'YYYY-MM-DD HH24:MI:SS'; ...