当前位置:Gxlcms > 数据库问题 > PostgreSQL时区调整

PostgreSQL时区调整

时间:2021-07-01 10:21:17 帮助过:235人阅读

# select now(); now ------------------------------ 2017-09-29 12:54:04.04916+08 (1 行记录)

查看时区:

  1. postgres<span style="color: #808080">=</span><span style="color: #000000"># show time zone;
  2. TimeZone
  3. </span><span style="color: #008080">--</span><span style="color: #008080">-------------</span>
  4. Asia<span style="color: #808080">/</span><span style="color: #000000">Shanghai
  5. (</span><span style="color: #800000; font-weight: bold">1</span> 行记录)

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

  1. postgres<span style="color: #808080">=</span># <span style="color: #0000ff">select</span> <span style="color: #808080">*</span> <span style="color: #0000ff">from</span><span style="color: #000000"> pg_timezone_names;
  2. name </span><span style="color: #808080">|</span> abbrev <span style="color: #808080">|</span> utc_offset <span style="color: #808080">|</span><span style="color: #000000"> is_dst
  3. </span><span style="color: #008080">--</span><span style="color: #008080">--------------------------------------+--------+------------+--------</span>
  4. Africa<span style="color: #808080">/</span>Abidjan <span style="color: #808080">|</span> GMT <span style="color: #808080">|</span> <span style="color: #800000; font-weight: bold">00</span>:<span style="color: #800000; font-weight: bold">00</span>:<span style="color: #800000; font-weight: bold">00</span> <span style="color: #808080">|</span><span style="color: #000000"> f
  5. Africa</span><span style="color: #808080">/</span>Accra <span style="color: #808080">|</span> GMT <span style="color: #808080">|</span> <span style="color: #800000; font-weight: bold">00</span>:<span style="color: #800000; font-weight: bold">00</span>:<span style="color: #800000; font-weight: bold">00</span> <span style="color: #808080">|</span><span style="color: #000000"> f
  6. Africa</span><span style="color: #808080">/</span>Addis_Ababa <span style="color: #808080">|</span> EAT <span style="color: #808080">|</span> <span style="color: #800000; font-weight: bold">03</span>:<span style="color: #800000; font-weight: bold">00</span>:<span style="color: #800000; font-weight: bold">00</span> <span style="color: #808080">|</span><span style="color: #000000"> f
  7. Africa</span><span style="color: #808080">/</span>Algiers <span style="color: #808080">|</span> CET <span style="color: #808080">|</span> <span style="color: #800000; font-weight: bold">01</span>:<span style="color: #800000; font-weight: bold">00</span>:<span style="color: #800000; font-weight: bold">00</span> <span style="color: #808080">|</span><span style="color: #000000"> f
  8. Africa</span><span style="color: #808080">/</span>Asmara <span style="color: #808080">|</span> EAT <span style="color: #808080">|</span> <span style="color: #800000; font-weight: bold">03</span>:<span style="color: #800000; font-weight: bold">00</span>:<span style="color: #800000; font-weight: bold">00</span> <span style="color: #808080">|</span><span style="color: #000000"> f
  9. Africa</span><span style="color: #808080">/</span>Asmera <span style="color: #808080">|</span> EAT <span style="color: #808080">|</span> <span style="color: #800000; font-weight: bold">03</span>:<span style="color: #800000; font-weight: bold">00</span>:<span style="color: #800000; font-weight: bold">00</span> <span style="color: #808080">|</span><span style="color: #000000"> f
  10. Africa</span><span style="color: #808080">/</span>Bamako <span style="color: #808080">|</span> GMT <span style="color: #808080">|</span> <span style="color: #800000; font-weight: bold">00</span>:<span style="color: #800000; font-weight: bold">00</span>:<span style="color: #800000; font-weight: bold">00</span> <span style="color: #808080">|</span><span style="color: #000000"> f
  11. Africa</span><span style="color: #808080">/</span>Bangui <span style="color: #808080">|</span> WAT <span style="color: #808080">|</span> <span style="color: #800000; font-weight: bold">01</span>:<span style="color: #800000; font-weight: bold">00</span>:<span style="color: #800000; font-weight: bold">00</span> <span style="color: #808080">|</span><span style="color: #000000"> f
  12. Africa</span><span style="color: #808080">/</span>Banjul <span style="color: #808080">|</span> GMT <span style="color: #808080">|</span> <span style="color: #800000; font-weight: bold">00</span>:<span style="color: #800000; font-weight: bold">00</span>:<span style="color: #800000; font-weight: bold">00</span> <span style="color: #808080">|</span><span style="color: #000000"> f
  13. Africa</span><span style="color: #808080">/</span>Bissau <span style="color: #808080">|</span> GMT <span style="color: #808080">|</span> <span style="color: #800000; font-weight: bold">00</span>:<span style="color: #800000; font-weight: bold">00</span>:<span style="color: #800000; font-weight: bold">00</span> <span style="color: #808080">|</span><span style="color: #000000"> f
  14. .......................</span>

设置时区:

  1. postgres<span style="color: #808080">=</span># <span style="color: #0000ff">set</span> time zone "Asia<span style="color: #808080">/</span><span style="color: #000000">Shanghai";
  2. </span><span style="color: #0000ff">SET</span>

 

 

PostgreSQL时区调整

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

人气教程排行