PostgreSQL How to compare time?

Question

PostgreSQL

Hello!
I encountered PostgreSQL for the first time .. help me make a query with time comparison:
There is a table cc_files with a lptime field (Format 2018-01-01 00:00:00).
How to write a query like: SELECT * from cc_files WHERE lptime < Current time minus interval variable (for example $t=1 HOUR )
I'm completely confused

Answer 1

Almost literally, this is what it says:

SELECT * from cc_files WHERE lptime < now() - interval '1 hour'