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:
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 t
: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]Sent: Monday, January
26, 2004 1:36 PMTo: '[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 -
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
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