How to calculate DATE Difference in PostgreSQL?

Question

In the PostgreSQL, I want to determine the distinction between the two dates.

In the SQL Server, it's much easier:

DATEDIFF(Day, MIN(joindate), MAX(joindate)) AS DateDifference;

I am attempting using the below script.

(Max(joindate) - Min(joindate)) as DateDifference;

Is my method correct and Is there any function in the PostgreSQL to calculate the same?

Answer 1

Your calculation is right for DATE types, though, if your values are timestamps, you should reasonably use EXTRACT (or DATE_PART) to be sure to get only the difference in full days;

EXTRACT(DAY FROM MAX(joindate)-MIN(joindate)) AS DateDifference

Also, note the timestamp difference being 1 second less than 2 full days.

Want to become an expert in SQL? Join the SQL online course fast!