How to subtract the calculated number of days from a date in Postgres?

Question

PostgreSQL

In the plate, a certain hour is written in the tick field. I have added a new ts column to the table and want to update it based on the tick column. And something does not work in postgres to write UPDATE.

In a db2 database, update would look like this

update set ts = (current_timestamp - (tick * 10 / 60 / 60 / 24) days) .

In postgres, the manual says something like But I can't translate it to my task. Tried

set ts = current_timestamp - interval '10 day'

set ts = current_timestamp - interval cast(tick * 10 / 60 / 60 / 24 as string) || ' day'

But there are syntax errors.

Answer 1

Found how.

set ts = current_timestamp - cast(tick * 10 / 60 / 60 / 24 as string) * interval '1 day'