How to migrate "as of timestamp" query in PostgreSQL

Question

I want to migrate or write an equivalent query to get the data from table one hr before the current time in PostgreSQL.

oracle query:

select * 
from T_DATA as of timestamp (systimestamp - interval '60' minute);

Answer 1

select * from T_DATA where timestamp_column >= now() - interval '1 hour'

Answer 2

Since flashback queries are not supported in postgresql, One approach I tried with temporal tables extension.