PostgreSQL時區調整

標籤：nbsp   gui   ica   names   iss   ...   word   code   bre   

查看資料庫的時區與時間:

postgres=# select now();               now              ------------------------------ 2017-09-29 12:54:04.04916+08(1 行記錄)

查看時區:

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時區調整