How to get the number of days between two dates with a query in PostgreSQL?

Question

PostgreSQL

I need to get the number of days between two dates with a query in PostgreSQL, and if the difference is negative, then get, for example, the number of days, that is, handle such a case. How to do it?

Answer 1

what prevents you from reading the doc https://www.postgresql.org/docs/12/functions-datet... or google it?