SQL date functions make SELECTs very slow but the real problem is that subtractions with CURDATE() can result in wrong results.
SQL date functions make SELECTs very slow but the real problem is that subtractions with CURDATE() can result in wrong results.
Comments
Comment #1
rsevero commentedFixed by commit #378044.
Comment #2
rsevero commentedJust for the record, one page that mentions SQL date functions shouldn't be used is How to write PostgreSQL-friendly SQL.