Postgres 12

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

select version();


version


PostgreSQL 12.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit


create table date_example( adate date, atimestamp timestamptz);
insert into date_example(adate,atimestamp) values (now()::date, now());
1 rows affected

select adate, to_char(adate,'yyyy-mm-dd') iso_format
            , to_char(adate,'mm-dd-yyyy') mdy_foramt
            , to_char(adate, 'FMDay FMddth FMMonth yyyy') Day_Month_year 
 from date_example;


adate
iso_format
mdy_foramt
day_month_year


2020-06-19
2020-06-19
06-19-2020
Friday 19th June 2020


select atimestamp, to_char( (atimestamp::at timezone 'UTC'),'yyyy-mm-dd hh24:mm:ss') at timezone 'UTC' mdy_foramt
                 , to_char(atimestamp, 'FMDay ddth FMMonth yyyy @ FMHH24:mi') Day_Month_year 
 from date_example;
ERROR:  syntax error at or near "timezone"
LINE 1: select atimestamp, to_char( (atimestamp::at timezone 'UTC'),...
                                                    ^