PostgreSQL 17beta1 A4 Documentation+ interval operator. date_add('2021-10-31 00:00:00+02'::timestamptz, '1 day'::interval, 'Europe/Warsaw') → 2021-10-31 23:00:00+00 date_bin ( interval, timestamp, timestamp ) → timestamp Bin input into interval operator. date_subtract('2021-11-01 00:00:00+01'::timestamptz, '1 day'::interval, 'Europe/Warsaw') → 2021-10-30 22:00:00+00 date_trunc ( text, timestamp ) → timestamp Truncate to specified precision; sales_east FOR VALUES IN ('Bejing', 'Delhi', 'Vladivostok'), PARTITION sales_central FOR VALUES IN ('Warsaw', 'Berlin', 'Kyiv')); To merge several partitions into one partition of the target table: ALTER0 码力 | 3017 页 | 14.45 MB | 1 年前3
PostgreSQL 17beta1 US Documentationinterval operator. date_add('2021-10-31 00:00:00+02'::timestamptz, '1 day'::in- terval, 'Europe/Warsaw') → 2021-10-31 23:00:00+00 date_bin ( interval, timestamp, timestamp ) → timestamp Bin input into interval operator. date_subtract('2021-11-01 00:00:00+01'::timestamptz, '1 day'::interval, 'Europe/Warsaw') → 2021-10-30 22:00:00+00 date_trunc ( text, timestamp ) → timestamp Truncate to specified precision; sales_east FOR VALUES IN ('Bejing', 'Delhi', 'Vladivostok'), PARTITION sales_central FOR VALUES IN ('Warsaw', 'Berlin', 'Kyiv')); To merge several partitions into one partition of the target table: ALTER0 码力 | 3188 页 | 14.32 MB | 1 年前3
PostgreSQL 8.0 DocumentationEurope/Tallinn Europe/Tirane Europe/Uzhgorod Europe/Vaduz Europe/Vienna Europe/Vilnius Europe/Warsaw Poland Europe/Zaporozhye Europe/Zurich Factory GMT GMT+0 GMT-0 GMT0 Greenwich Etc/GMT Etc/GMT+00 码力 | 1422 页 | 9.92 MB | 1 年前3
PostgreSQL 8.0 DocumentationEurope/Tallinn Europe/Tirane Europe/Uzhgorod Europe/Vaduz Europe/Vienna Europe/Vilnius Europe/Warsaw Poland Europe/Zaporozhye Europe/Zurich Factory GMT GMT+0 GMT-0 GMT0 Greenwich Etc/GMT Etc/GMT+00 码力 | 1332 页 | 9.76 MB | 1 年前3
PostgreSQL 8.1.11 DocumentationEurope/Tallinn Europe/Tirane Europe/Uzhgorod Europe/Vaduz Europe/Vienna Europe/Vilnius Europe/Warsaw Poland Europe/Zaporozhye Europe/Zurich Factory GMT GMT+0 GMT-0 GMT0 Greenwich Etc/GMT Etc/GMT+00 码力 | 1582 页 | 12.19 MB | 1 年前3
PostgreSQL 8.1 DocumentationEurope/Tallinn Europe/Tirane Europe/Uzhgorod Europe/Vaduz Europe/Vienna Europe/Vilnius Europe/Warsaw Poland Europe/Zaporozhye Europe/Zurich Factory GMT GMT+0 GMT-0 GMT0 Greenwich Etc/GMT Etc/GMT+00 码力 | 1548 页 | 11.54 MB | 1 年前3
PostgreSQL 16.1 Documentationinterval operator. date_add('2021-10-31 00:00:00+02'::timestamptz, '1 day'::in- terval, 'Europe/Warsaw') → 2021-10-31 23:00:00+00 date_bin ( interval, timestamp, timestamp ) → timestamp Bin input into interval operator. date_subtract('2021-11-01 00:00:00+01'::timestamptz, '1 day'::interval, 'Europe/Warsaw') → 2021-10-30 22:00:00+00 date_trunc ( text, timestamp ) → timestamp Truncate to specified precision;0 码力 | 3133 页 | 14.10 MB | 1 年前3
PostgreSQL 16.1 Documentation+ interval operator. date_add('2021-10-31 00:00:00+02'::timestamptz, '1 day'::interval, 'Europe/Warsaw') → 2021-10-31 23:00:00+00 date_bin ( interval, timestamp, timestamp ) → timestamp Bin input into interval operator. date_subtract('2021-11-01 00:00:00+01'::timestamptz, '1 day'::interval, 'Europe/Warsaw') → 2021-10-30 22:00:00+00 date_trunc ( text, timestamp ) → timestamp Truncate to specified precision;0 码力 | 2974 页 | 14.22 MB | 1 年前3
共 8 条
- 1













