-
Hi, Guys
I am trying to find out when Oracle change its time when time in OS was changed. As I can see it chanes time only when you reconnect.
Any ideas are very wellcome.
=============================
SVRMGR> select to_char(sysdate,'SS.MI.HH24 DD/MM/YYY') from dual;
TO_CHAR(SYSDATE,'S
------------------
05.45.14 05/07/002
1 row selected.
[oracle@mci oracle]$ date
Fri Jul 5 14:45:20 GMT 2002
[oracle@mci oracle]$ exit
exit
SVRMGR> select to_char(sysdate,'SS.MI.HH24 DD/MM/YYY') from dual;
TO_CHAR(SYSDATE,'S
------------------
25.45.14 05/07/002
1 row selected.
*********** Time changed, but Oracle does not ********
[oracle@mci oracle]$ date
Fri Jul 5 15:50:23 IST 2002
[oracle@mci oracle]$ exit
exit
SVRMGR> select to_char(sysdate,'SS.MI.HH24 DD/MM/YYY') from dual;
TO_CHAR(SYSDATE,'S
------------------
38.50.14 05/07/002
1 row selected.
SVRMGR> !
[oracle@mci oracle]$ date
Fri Jul 5 15:50:44 IST 2002
=== New session ==================================================
SVRMGR> connect internal;
Connected.
SVRMGR> select to_char(sysdate,'SS.MI.HH24 DD/MM/YYY') from dual;
TO_CHAR(SYSDATE,'S
------------------
40.53.15 05/07/002
1 row selected.
SVRMGR> !
[oracle@mci oracle]$ date
Fri Jul 5 15:53:43 IST 2002
Best wishes!
Dmitri
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|