Trying to 1 year to date from other column

Get Help
1

Hey there I am trying to use the date given from column A add 1 year and create a new column B. This is what I have at the moment

SELECT "customers.first_name" AS "first_name", "customers.last_points_transaction_at" AS "last_points_transaction_at",
"customers.last_points_transaction_at" + ("customers.last_points_transaction_at" * interval '1 year') AS "expiry_date"
FROM "public"."customers"

I know this is wrong but I have no idea where to start fixing it

I get this error when I run ERROR: operator does not exist: timestamp without time zone * interval Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 455

Hoping someone can help

2

this entirely depends on the database engine that you're querying, if you could send the diagnostic info that would be great so we can provide you some help with the matter