Ken Winter wrote:
> How can a column’s default be set to ‘now’, meaning ‘now’ as of when
> each row is inserted?
>
>
>
> For example, here’s a snip of DDL:
>
>
>
> create table personal_data (…
>
> effective_date_and_time TIMESTAMP WITH TIME ZONE not null default 'now',…
>
try with now(), instead of now
...
effective_date_and_time TIMESTAMPTZ not null default now()...