PostgreSQL时区调整

查看时区:

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

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

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; 
                  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 
</span><span style="color: #008080">--</span><span style="color: #008080">--------------------------------------+--------+------------+--------</span>
 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
 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
 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
 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
 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
 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
 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
 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
 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
 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
.......................</span>

设置时区:

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";
</span><span style="color: #0000ff">SET</span>

PostgreSQL时区调整

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