How to set a Date / timestamp attribute on an item and update it in Postgres

Questions
4

Did you figure out this? PostgreSQL will automatically apply a cast operator from the input data type to the table’s type. It has a built-in cast operator from string to timestamp, so as long as your string is formatted in a way that PostgreSQL can parse, you should be fine.

Example SQL:

create table tst(
	ts timestamp not null
);

insert into tst(ts) values('2020-10-02');
select * from tst;