What is the difference between `DATEDIFF()` in MySQL vs `age()` in PostgreSQL for date arithmetic?

Question

Advanced SQL Developer — Medium

What is the difference between `DATEDIFF()` in MySQL vs `age()` in PostgreSQL for date arithmetic?

Accepted Answer

MySQL's DATEDIFF() and PostgreSQL's age() differ in their output types for date arithmetic. DATEDIFF() returns the difference in whole days as an integer, while age() returns an interval with calendar-aware components. This distinction makes them solve date differences differently.