Tom Lane wrote:
>
>
>Has anyone done the corresponding experiments on the other DBMSes to
>identify exactly when they allow CURRENT_TIMESTAMP to advance ?
>
This applies up to Oracle 8.1.6, maybe it helps:
According to a co-worker, Oracle advances the time in transactions:
select to_char(sysdate, 'dd.mm.yyyy hh24:mi:ss') from dual;
TO_CHAR(SYSDATE,'DD
-------------------
03.10.2002 10:16:28
(wait ...)
SQL> r
1* select to_char(sysdate, 'dd.mm.yyyy hh24:mi:ss') from dual
TO_CHAR(SYSDATE,'DD
-------------------
03.10.2002 10:17:41
It even advances within procedures/functions, example:
create or replace procedure foobar is
s1 varchar(2000);
s2 varchar(2000);
begin
select to_char(sysdate, 'dd.mm.yyyy hh24:mi:ss') into s1 from dual;
(... put long running query here ...)
select to_char(sysdate, 'dd.mm.yyyy hh24:mi:ss') into s2 from dual;
dbms_output.put_line(s1);
dbms_output.put_line(s2);
end;
/
set serverout on
execute foobar;
Hope it helps.
Regards,
Mario Weilguni
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
