时间:2021-07-01 10:21:17 帮助过:235人阅读
查看时区:
- 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