RE: Getting sysdate across a DB link

[Mercadante, Thomas F]

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. 

 

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Ashish Sahasrabudhe [mailto:[EMAIL PROTECTED]
Sent: Monday, January 26, 2004 11:14 AM
To: Multiple recipients of list ORACLE-L
Subject: 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 local_date, remote_date from ( select sysdate remote_date from [EMAIL PROTECTED])

How can this be done?

Thanks