RE: Getting sysdate across a DB link

[Ashish Sahasrabudhe]

Title: Getting sysdate across a DB link

The dates are different. Currently remote server is GMT and local is EST and this can change.

I was looking for something without creating any database object like function or view on the remote server.

 

Thanks

-----Original Message-----
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]
Sent: Monday, January 26, 2004 1:36 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: 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