http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FDate_Timezone%2FCURRENT_TIMESTAMP
Oracle PL/SQL/Date Timezone/CURRENT TIMESTAMP - История изменений
2026-05-24T22:39:17Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=Oracle_PL/SQL/Date_Timezone/CURRENT_TIMESTAMP&diff=2456&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://www.sqle.ru/index.php?title=Oracle_PL/SQL/Date_Timezone/CURRENT_TIMESTAMP&diff=2457&oldid=prev
Admin: 1 версия
2010-05-26T10:01:36Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Compare the timestamp value between before and after "alter session set time_zone"==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> create table t<br />
2 (c1 timestamp with time zone,<br />
3 c2 timestamp with local time zone)<br />
4 /<br />
Table created.<br />
SQL><br />
SQL> insert into t (c1,c2)values( current_timestamp, current_timestamp );<br />
1 row created.<br />
SQL><br />
SQL> select * from t;<br />
C1<br />
---------------------------------------------------------------------------<br />
C2<br />
---------------------------------------------------------------------------<br />
16-JUN-08 05.01.27.439000 PM -08:00<br />
16-JUN-08 05.01.27.439000 PM<br />
<br />
1 row selected.<br />
SQL><br />
SQL> alter session set time_zone = "-08:00";<br />
Session altered.<br />
SQL><br />
SQL> select * from t;<br />
C1<br />
---------------------------------------------------------------------------<br />
C2<br />
---------------------------------------------------------------------------<br />
16-JUN-08 05.01.27.439000 PM -08:00<br />
16-JUN-08 05.01.27.439000 PM<br />
<br />
1 row selected.<br />
SQL><br />
SQL> drop table t;<br />
Table dropped.<br />
SQL><br />
SQL> --<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==CURRENT_TIMESTAMP(): containing the current session time along with the session time zone==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> --CURRENT_TIMESTAMP(): containing the current session time along with the session time zone.<br />
SQL><br />
SQL> SELECT CURRENT_TIMESTAMP FROM dual;<br />
CURRENT_TIMESTAMP<br />
---------------------------------------------------------------------------<br />
16-SEP-06 08.35.05.062000 PM EST<br />
SQL><br />
<br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Insert a row using the CURRENT_TIMESTAMP function==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL><br />
SQL> create table t<br />
2 (c1 timestamp with time zone,<br />
3 c2 timestamp with local time zone)<br />
4 /<br />
Table created.<br />
SQL><br />
SQL> insert into t (c1,c2)values( current_timestamp, current_timestamp );<br />
1 row created.<br />
SQL><br />
SQL> select * from t;<br />
C1<br />
---------------------------------------------------------------------------<br />
C2<br />
---------------------------------------------------------------------------<br />
16-JUN-08 05.01.26.317000 PM -08:00<br />
16-JUN-08 05.01.26.317000 PM<br />
<br />
1 row selected.<br />
SQL><br />
SQL> alter session set time_zone = "-08:00";<br />
Session altered.<br />
SQL><br />
SQL> select * from t;<br />
C1<br />
---------------------------------------------------------------------------<br />
C2<br />
---------------------------------------------------------------------------<br />
16-JUN-08 05.01.26.317000 PM -08:00<br />
16-JUN-08 05.01.26.317000 PM<br />
<br />
1 row selected.<br />
SQL><br />
SQL> drop table t;<br />
Table dropped.<br />
SQL><br />
SQL> --<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==select current_timestamp from dual to see the session time==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> select current_timestamp from dual;<br />
<br />
CURRENT_TIMESTAMP<br />
------------------------------------------------------<br />
26-OCT-09 10.31.37.075000 AM -06:00<br />
1 row selected.<br />
SQL><br />
<br />
<br />
</source></div>
Admin