内容

pg_timezone_abbrevs

提供时区缩写列表的系统视图

pg_timezone_abbrevs 是一个提供当前日期时间输入例程识别的时区缩写列表的系统目录视图。

pg_timezone_abbrevs 在PostgreSQL 8.2中添加。

按 PostgreSQL 版本定义

pg_timezone_abbrevs (PostgreSQL 17)

         View "pg_catalog.pg_timezone_abbrevs"
   Column   |   Type   | Collation | Nullable | Default 
------------+----------+-----------+----------+---------
 abbrev     | text     |           |          | 
 utc_offset | interval |           |          | 
 is_dst     | boolean  |           |          |

文档: pg_timezone_abbrevs

pg_timezone_abbrevs (PostgreSQL 16)

         View "pg_catalog.pg_timezone_abbrevs"
   Column   |   Type   | Collation | Nullable | Default 
------------+----------+-----------+----------+---------
 abbrev     | text     |           |          | 
 utc_offset | interval |           |          | 
 is_dst     | boolean  |           |          |

文档: pg_timezone_abbrevs

pg_timezone_abbrevs (PostgreSQL 15)

         View "pg_catalog.pg_timezone_abbrevs"
   Column   |   Type   | Collation | Nullable | Default 
------------+----------+-----------+----------+---------
 abbrev     | text     |           |          | 
 utc_offset | interval |           |          | 
 is_dst     | boolean  |           |          |

文档: pg_timezone_abbrevs

pg_timezone_abbrevs (PostgreSQL 14)

         View "pg_catalog.pg_timezone_abbrevs"
   Column   |   Type   | Collation | Nullable | Default 
------------+----------+-----------+----------+---------
 abbrev     | text     |           |          | 
 utc_offset | interval |           |          | 
 is_dst     | boolean  |           |          |

文档: pg_timezone_abbrevs

pg_timezone_abbrevs (PostgreSQL 13)

         View "pg_catalog.pg_timezone_abbrevs"
   Column   |   Type   | Collation | Nullable | Default 
------------+----------+-----------+----------+---------
 abbrev     | text     |           |          | 
 utc_offset | interval |           |          | 
 is_dst     | boolean  |           |          |

文档: pg_timezone_abbrevs

pg_timezone_abbrevs (PostgreSQL 12)

         View "pg_catalog.pg_timezone_abbrevs"
   Column   |   Type   | Collation | Nullable | Default 
------------+----------+-----------+----------+---------
 abbrev     | text     |           |          | 
 utc_offset | interval |           |          | 
 is_dst     | boolean  |           |          |

文档: pg_timezone_abbrevs

pg_timezone_abbrevs (PostgreSQL 11)

         View "pg_catalog.pg_timezone_abbrevs"
   Column   |   Type   | Collation | Nullable | Default 
------------+----------+-----------+----------+---------
 abbrev     | text     |           |          | 
 utc_offset | interval |           |          | 
 is_dst     | boolean  |           |          |

文档: pg_timezone_abbrevs

pg_timezone_abbrevs (PostgreSQL 10)

         View "pg_catalog.pg_timezone_abbrevs"
   Column   |   Type   | Collation | Nullable | Default 
------------+----------+-----------+----------+---------
 abbrev     | text     |           |          | 
 utc_offset | interval |           |          | 
 is_dst     | boolean  |           |          |

文档: pg_timezone_abbrevs

pg_timezone_abbrevs (PostgreSQL 9.6)

View "pg_catalog.pg_timezone_abbrevs"
   Column   |   Type   | Modifiers 
------------+----------+-----------
 abbrev     | text     | 
 utc_offset | interval | 
 is_dst     | boolean  |

文档: pg_timezone_abbrevs

pg_timezone_abbrevs (PostgreSQL 9.5)

View "pg_catalog.pg_timezone_abbrevs"
   Column   |   Type   | Modifiers 
------------+----------+-----------
 abbrev     | text     | 
 utc_offset | interval | 
 is_dst     | boolean  |

文档: pg_timezone_abbrevs

pg_timezone_abbrevs (PostgreSQL 9.4)

View "pg_catalog.pg_timezone_abbrevs"
   Column   |   Type   | Modifiers 
------------+----------+-----------
 abbrev     | text     | 
 utc_offset | interval | 
 is_dst     | boolean  |

文档: pg_timezone_abbrevs

pg_timezone_abbrevs (PostgreSQL 9.3)

View "pg_catalog.pg_timezone_abbrevs"
   Column   |   Type   | Modifiers 
------------+----------+-----------
 abbrev     | text     | 
 utc_offset | interval | 
 is_dst     | boolean  |

文档: pg_timezone_abbrevs

pg_timezone_abbrevs (PostgreSQL 9.2)

View "pg_catalog.pg_timezone_abbrevs"
   Column   |   Type   | Modifiers 
------------+----------+-----------
 abbrev     | text     | 
 utc_offset | interval | 
 is_dst     | boolean  |

文档: pg_timezone_abbrevs

pg_timezone_abbrevs (PostgreSQL 9.1)

View "pg_catalog.pg_timezone_abbrevs"
   Column   |   Type   | Modifiers 
------------+----------+-----------
 abbrev     | text     | 
 utc_offset | interval | 
 is_dst     | boolean  |

文档: pg_timezone_abbrevs

pg_timezone_abbrevs (PostgreSQL 9.0)

View "pg_catalog.pg_timezone_abbrevs"
   Column   |   Type   | Modifiers 
------------+----------+-----------
 abbrev     | text     | 
 utc_offset | interval | 
 is_dst     | boolean  |

文档: pg_timezone_abbrevs

pg_timezone_abbrevs (PostgreSQL 8.4)

View "pg_catalog.pg_timezone_abbrevs"
   Column   |   Type   | Modifiers 
------------+----------+-----------
 abbrev     | text     | 
 utc_offset | interval | 
 is_dst     | boolean  | 
View definition:
 SELECT pg_timezone_abbrevs.abbrev, pg_timezone_abbrevs.utc_offset, pg_timezone_abbrevs.is_dst
   FROM pg_timezone_abbrevs() pg_timezone_abbrevs(abbrev, utc_offset, is_dst);

文档: pg_timezone_abbrevs

pg_timezone_abbrevs (PostgreSQL 8.3)

View "pg_catalog.pg_timezone_abbrevs"
   Column   |   Type   | Modifiers 
------------+----------+-----------
 abbrev     | text     | 
 utc_offset | interval | 
 is_dst     | boolean  | 
View definition:
 SELECT pg_timezone_abbrevs.abbrev, pg_timezone_abbrevs.utc_offset, pg_timezone_abbrevs.is_dst
   FROM pg_timezone_abbrevs() pg_timezone_abbrevs(abbrev, utc_offset, is_dst);

文档: pg_timezone_abbrevs

pg_timezone_abbrevs (PostgreSQL 8.2)

View "pg_catalog.pg_timezone_abbrevs"
   Column   |   Type   | Modifiers 
------------+----------+-----------
 abbrev     | text     | 
 utc_offset | interval | 
 is_dst     | boolean  | 
View definition:
 SELECT pg_timezone_abbrevs.abbrev, pg_timezone_abbrevs.utc_offset, pg_timezone_abbrevs.is_dst
   FROM pg_timezone_abbrevs() pg_timezone_abbrevs(abbrev, utc_offset, is_dst);

文档: pg_timezone_abbrevs

更改历史

pg_timezone_abbrevs 自PostgreSQL 8.2中添加以来未被修改过。

示例

postgres=# SELECT * FROM pg_timezone_abbrevs WHERE abbrev LIKE 'C%';
 abbrev | utc_offset | is_dst
--------+------------+--------
 CADT   | 10:30:00   | t
 CAST   | 09:30:00   | f
 CCT    | 08:00:00   | f
 CDT    | -05:00:00  | t
 CEST   | 02:00:00   | t
 CET    | 01:00:00   | f
 CETDST | 02:00:00   | t
 CHADT  | 13:45:00   | t
 CHAST  | 12:45:00   | f
 CHUT   | 10:00:00   | f
 CKT    | -10:00:00  | f
 CLST   | -03:00:00  | t
 CLT    | -04:00:00  | f
 COT    | -05:00:00  | f
 CST    | -06:00:00  | f
 CXT    | 07:00:00   | f
(16 rows)

分类

日期和时间, 系统目录

另请参阅

timezone_abbreviations, pg_timezone_names

反馈

提交任何关于 "pg_timezone_abbrevs" 的评论、建议或更正 此处.