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. Read More
MySQL: finding number of days different
While working on an invoice system, I want to project a list of invoices that are overdue for certain amount of days, or a list of invoices that are going to be due in certain amount of days. Instead of implementing the filtering in PHP code, I am thinking to let MySQL query performs the filtering.
Read More