Home » SQL & PL/SQL » SQL & PL/SQL » SYSDATE of remote database
SYSDATE of remote database [message #18730] Tue, 12 February 2002 15:36 Go to next message
Sumesh
Messages: 3
Registered: February 2002
Junior Member
Hi All,

How to get the SYSDATE of a remote database without creating any objects in the remote database? SELECT SYSDATE FROM DUAL@db_link returns the local database timestamp.

Thanks in Advance.

Report message to a moderator

Re: SYSDATE of remote database [message #18731 is a reply to message #18730] Tue, 12 February 2002 16:30 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
I am not aware of a way to get a remote sysdate without building a function at the remote that returns sysdate.

All documentation I have seen says that sysdate is always evaluated within the local context.

Report message to a moderator

Re: SYSDATE of remote database [message #18750 is a reply to message #18730] Wed, 13 February 2002 05:54 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
Connect directly to the database and and do a "select sysdate from dual" and put the date in a variable if you need it locally.

Report message to a moderator

Re: SYSDATE of remote database [message #18759 is a reply to message #18750] Wed, 13 February 2002 07:40 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
That works if you are just executing a script, but not in a PL/SQL context.

Report message to a moderator

Previous Topic: explain plan
Next Topic: how to read from the collection ..
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 08:03:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.