http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2Ftimezone_names Oracle PL/SQL/System Tables Views/timezone names - История изменений 2026-04-07T04:49:28Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/timezone_names&diff=2230&oldid=prev в 13:45, 26 мая 2010 2010-05-26T13:45:19Z <p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table> http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/timezone_names&diff=2231&oldid=prev Admin: 1 версия 2010-05-26T10:01:13Z <p>1 версия</p> <p><b>Новая страница</b></p><div>==Find time zones for a given UTC offset:==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> SQL&gt;<br /> SQL&gt; select tzname, tzabbrev<br /> 2 from v$timezone_names<br /> 3 where substr( tz_offset(tzname), 1,6) = &quot;-06:00&quot;;<br /> TZNAME<br /> ----------------------------------------------------------------<br /> TZABBREV<br /> ----------------------------------------------------------------<br /> America/Boise<br /> LMT<br /> America/Boise<br /> PST<br /> America/Boise<br /> PWT<br /> America/Boise<br /> MST<br /> America/Boise<br /> MWT<br /> America/Boise<br /> MDT<br /> America/Cambridge_Bay<br /> LMT<br /> America/Cambridge_Bay<br /> MST<br /> America/Cambridge_Bay<br /> MDT<br /> America/Cambridge_Bay<br /> MDDT<br /> America/Cambridge_Bay<br /> CST<br /> America/Cambridge_Bay<br /> CDT<br /> America/Cambridge_Bay<br /> EST<br /> America/Chihuahua<br /> LMT<br /> America/Chihuahua<br /> MST<br /> America/Chihuahua<br /> CST<br /> America/Chihuahua<br /> CDT<br /> America/Chihuahua<br /> MDT<br /> America/Costa_Rica<br /> LMT<br /> America/Costa_Rica<br /> SJMT<br /> America/Costa_Rica<br /> CST<br /> America/Costa_Rica<br /> CDT<br /> America/Denver<br /> LMT<br /> America/Denver<br /> MST<br /> America/Denver<br /> MWT<br /> America/Denver<br /> MDT<br /> America/Edmonton<br /> LMT<br /> America/Edmonton<br /> MST<br /> America/Edmonton<br /> MDT<br /> America/El_Salvador<br /> LMT<br /> America/El_Salvador<br /> CST<br /> America/El_Salvador<br /> CDT<br /> America/Guatemala<br /> LMT<br /> America/Guatemala<br /> CST<br /> America/Guatemala<br /> CDT<br /> America/Inuvik<br /> LMT<br /> America/Inuvik<br /> PST<br /> America/Inuvik<br /> PDT<br /> America/Inuvik<br /> PDDT<br /> America/Inuvik<br /> MST<br /> America/Inuvik<br /> MDT<br /> America/Managua<br /> LMT<br /> America/Managua<br /> MMT<br /> America/Managua<br /> CST<br /> America/Managua<br /> EST<br /> America/Managua<br /> CDT<br /> America/Mazatlan<br /> LMT<br /> America/Mazatlan<br /> MST<br /> America/Mazatlan<br /> CST<br /> America/Mazatlan<br /> PST<br /> America/Mazatlan<br /> MDT<br /> America/Regina<br /> LMT<br /> America/Regina<br /> MST<br /> America/Regina<br /> MDT<br /> America/Regina<br /> CST<br /> America/Shiprock<br /> LMT<br /> America/Shiprock<br /> MST<br /> America/Shiprock<br /> MWT<br /> America/Shiprock<br /> MDT<br /> America/Swift_Current<br /> LMT<br /> America/Swift_Current<br /> MST<br /> America/Swift_Current<br /> MDT<br /> America/Swift_Current<br /> CST<br /> America/Tegucigalpa<br /> LMT<br /> America/Tegucigalpa<br /> CST<br /> America/Tegucigalpa<br /> CDT<br /> America/Yellowknife<br /> LMT<br /> America/Yellowknife<br /> MST<br /> America/Yellowknife<br /> MDT<br /> America/Yellowknife<br /> MDDT<br /> Canada/East-Saskatchewan<br /> LMT<br /> Canada/East-Saskatchewan<br /> MST<br /> Canada/East-Saskatchewan<br /> MDT<br /> Canada/East-Saskatchewan<br /> CST<br /> Canada/Mountain<br /> LMT<br /> Canada/Mountain<br /> MST<br /> Canada/Mountain<br /> MDT<br /> Canada/Saskatchewan<br /> LMT<br /> Canada/Saskatchewan<br /> MST<br /> Canada/Saskatchewan<br /> MDT<br /> Canada/Saskatchewan<br /> CST<br /> Chile/EasterIsland<br /> LMT<br /> Chile/EasterIsland<br /> MMT<br /> Chile/EasterIsland<br /> EAST<br /> Chile/EasterIsland<br /> EASST<br /> Etc/GMT+6<br /> GMT+6<br /> Mexico/BajaSur<br /> LMT<br /> Mexico/BajaSur<br /> MST<br /> Mexico/BajaSur<br /> CST<br /> Mexico/BajaSur<br /> PST<br /> Mexico/BajaSur<br /> MDT<br /> MST<br /> LMT<br /> MST<br /> MST<br /> MST<br /> MWT<br /> MST<br /> MDT<br /> MST7MDT<br /> LMT<br /> MST7MDT<br /> MST<br /> MST7MDT<br /> MWT<br /> MST7MDT<br /> MDT<br /> Navajo<br /> LMT<br /> Navajo<br /> MST<br /> Navajo<br /> MWT<br /> Navajo<br /> MDT<br /> Pacific/Easter<br /> LMT<br /> Pacific/Easter<br /> MMT<br /> Pacific/Easter<br /> EAST<br /> Pacific/Easter<br /> EASST<br /> US/Mountain<br /> LMT<br /> US/Mountain<br /> MST<br /> US/Mountain<br /> MWT<br /> US/Mountain<br /> MDT<br /> <br /> 111 rows selected.<br /> SQL&gt;<br /> SQL&gt; --<br /> &lt;/source&gt;</div> Admin