|
2 | 2 | -- HOROLOGY |
3 | 3 | -- |
4 | 4 | -- |
| 5 | +-- date, time arithmetic |
| 6 | +-- |
| 7 | +SELECT date '1981-02-03' + time '04:05:06' AS "Date + Time"; |
| 8 | + Date + Time |
| 9 | +------------------------------ |
| 10 | + Tue Feb 03 04:05:06 1981 PST |
| 11 | +(1 row) |
| 12 | + |
| 13 | +SELECT date '1991-02-03' + time with time zone '04:05:06 PST' AS "Date + Time PST"; |
| 14 | + Date + Time PST |
| 15 | +------------------------------ |
| 16 | + Sun Feb 03 04:05:06 1991 PST |
| 17 | +(1 row) |
| 18 | + |
| 19 | +SELECT date '2001-02-03' + time with time zone '04:05:06 UTC' AS "Date + Time UTC"; |
| 20 | + Date + Time UTC |
| 21 | +------------------------------ |
| 22 | + Fri Feb 02 20:05:06 2001 PST |
| 23 | +(1 row) |
| 24 | + |
| 25 | +SELECT date '1991-02-03' + interval '2 years' AS "Add Two Years"; |
| 26 | + Add Two Years |
| 27 | +------------------------------ |
| 28 | + Wed Feb 03 00:00:00 1993 PST |
| 29 | +(1 row) |
| 30 | + |
| 31 | +SELECT date '2001-12-13' - interval '2 years' AS "Subtract Two Years"; |
| 32 | + Subtract Two Years |
| 33 | +------------------------------ |
| 34 | + Mon Dec 13 00:00:00 1999 PST |
| 35 | +(1 row) |
| 36 | + |
| 37 | +SELECT date '1991-02-03' - time '04:05:06' AS "Subtract Time"; |
| 38 | + Subtract Time |
| 39 | +------------------------------ |
| 40 | + Sat Feb 02 19:54:54 1991 PST |
| 41 | +(1 row) |
| 42 | + |
| 43 | +SELECT date '1991-02-03' - time with time zone '04:05:06 UTC' AS "Subtract Time UTC"; |
| 44 | +ERROR: Unable to identify an operator '-' for types 'date' and 'timetz' |
| 45 | +You will have to retype this query using an explicit cast |
| 46 | +-- |
5 | 47 | -- timestamp, interval arithmetic |
6 | 48 | -- |
7 | 49 | SELECT timestamp '1996-03-01' - interval '1 second' AS "Feb 29"; |
|