create temporary table junk as select now()::date as evtdate;
alter table junk add column chardate text GENERATED ALWAYS AS(to_char(evtdate,'YYYY-Mon-DD')) STORED;
ERROR: generation expression is not immutable