Would it really kill PostgreSQL to include a DATEADD function?! 😖
Conversation
Replying to
You mean like `SELECT '2020-01-01'::date + 5` to add 5 days? That works.
Replying to
I'm trying to extract a financial year from a calendar year so I'm doing some (possibly silly) math around months. Trying to add n months with "mydate + (n * INTERVAL '1 month')" returns "Interval values with month or year parts are not supported"
2
I built my database on Postgres, and its dates are still a bit scary (for someone who uses SQL all day every day).
1
Show replies