Opérateurs sur les dates dans les requêtes PostgreSQL
posté le 20 juillet 2022
date + integer → date
date '2021-09-28' + 7 → 2021-10-05
date + interval → timestamp
date '2021-09-28' + interval '1 hour' → 2021-09-28 01:00:00
date + time → timestamp
date '2021-09-28' + time '03:00' → 2021-09-28 03:00:00
interval + interval → interval
interval '1 day' + interval '1 hour' → 1 day 01:00:00
timestamp + interval → timestamp
timestamp '2021-09-28 01:00' + interval '23 hours' → 2021-09-29 00:00:00
time + interval → time
time '01:00' + interval '3 hours' → 04:00:00
- interval → interval
- interval '23 hours' → -23:00:00
date - date → integer
date '2021-10-01' - date '2021-09-28' → 3
date - integer → date
date '2021-10-01' - 7 → 2021-09-24
date - interval → timestamp
date '2021-09-28' - interval '1 hour' 2021-09-27 23:00:00
time - time → interval
time '05:00' - time '03:00' → 02:00:00
time - interval → time
time '05:00' - interval '2 hours' → 03:00:00
timestamp - interval → timestamp
timestamp '2021-09-28 23:00' - interval '23 hours' → 2021-09-28 00:00:00
interval - interval → interval
interval '1 day' - interval '1 hour' → 1 day -01:00:00
timestamp - timestamp → interval
timestamp '2021-09-29 03:00' - timestamp '2021-07-27 12:00' → 63 days 15:00:00
interval * double precision → interval
interval '1 second' * 900 → 00:15:00
interval '1 day' * 21 → 21 days
interval '1 hour' * 3.5 → 03:30:00
interval / double precision → interval
interval '1 hour' / 1.5 → 00:40:00