Title: Getting sysdate across a DB link
I'm trying to get the value of SYSDATE on a remote server. I have a
database link to the server, but I'm not sure how to force SYSDATE to
be evaluated on the remote machine.
Following query gives same results, both dates are same.
select sysdate
Create procedure get_date on the remote node and invoke it over the DB
link.
On 01/26/2004 11:14:26 AM, Ashish Sahasrabudhe wrote:
I'm trying to get the value of SYSDATE on a remote server. I have a
database link to the server, but I'm not sure how to force SYSDATE to
be evaluated on the remote
Title: Getting sysdate across a DB link
Ashish,
Why do
you think that the dates would be different on the two machines - is one across
the international date line? Shouldn't the dates be the
same?
How
about getting the time from both servers - they *might be* different by a few
seconds
Title: Getting sysdate across a DB link
The
dates are different. Currentlyremote serverisGMT
andlocalis EST and this can change.
I was
looking for something without creating any database object like function or
viewon the remote server.
Thanks
-Original Message-From: Mercadante
On 01/26/2004 01:34:24 PM, Mercadante, Thomas F wrote:
Ashish,
Why do you think that the dates would be different on the two
machines
- is
one across the international date line? Shouldn't the dates be the
same?
Thomas, if we learned anything from Einstein, it is that the time is
relative to
Mladen,
there you go again! LOL.
now go back and trade your Wang in for a new one.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday, January 26, 2004 2:04 PM
To: Multiple recipients of list ORACLE-L
On 01/26/2004 01:34:24 PM, Mercadante, Thomas F wrote: