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?