In my previous post about “MySQL: finding number of days different”, there is example of how to get number of days different from 2 date. However, the SQL command is not valid for postgreSQL. PostgreSQL does not support for the query syntax TO_DAYS(). Fortunately, there is alternative method to get number of days different with other syntax for PostgreSQL.
This query command for PostgreSQL to determine number of days different from 2 given date is simple and clean as what MySQL does.
SELECT * FROM tblData WHERE (CURRENT_DATE - join_date) > 0
