PostgreSQL时区调整

查看时区:

postgres=# show time zone;
   TimeZone    
---------------
 Asia/Shanghai
(1 行记录)

查看数据库可供选择的时区:

postgres=#  select * from pg_timezone_names; 
                  name                  | abbrev | utc_offset | is_dst 
----------------------------------------+--------+------------+--------
 Africa/Abidjan                         | GMT    | 00:00:00   | f
 Africa/Accra                           | GMT    | 00:00:00   | f
 Africa/Addis_Ababa                     | EAT    | 03:00:00   | f
 Africa/Algiers                         | CET    | 01:00:00   | f
 Africa/Asmara                          | EAT    | 03:00:00   | f
 Africa/Asmera                          | EAT    | 03:00:00   | f
 Africa/Bamako                          | GMT    | 00:00:00   | f
 Africa/Bangui                          | WAT    | 01:00:00   | f
 Africa/Banjul                          | GMT    | 00:00:00   | f
 Africa/Bissau                          | GMT    | 00:00:00   | f
.......................

设置时区:

postgres=# set time zone "Asia/Shanghai";
SET

PostgreSQL时区调整

标签：nbsp   gui   ica   names   iss   ...   word   code   bre