SQL date functions make SELECTs very slow but the real problem is that subtractions with CURDATE() can result in wrong results.

Comments

rsevero’s picture

Status: Active » Fixed

Fixed by commit #378044.

rsevero’s picture

Just for the record, one page that mentions SQL date functions shouldn't be used is How to write PostgreSQL-friendly SQL.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.