Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Getting sysdate across a DB link
Content-Type: text/plain;
charset="iso-8859-1"
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-----
Sent: Monday, January 26, 2004 11:14 AM
To: Multiple recipients of list ORACLE-L
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 dual_at_remote_db)
How can this be done?
Thanks
------_=_NextPart_001_01C3E43B.41344E7A
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Getting sysdate across a DB link</TITLE>
<META content="MSHTML 5.50.4934.1600" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=756152718-26012004>Ashish,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=756152718-26012004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=756152718-26012004>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?</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=756152718-26012004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=756152718-26012004>How
about getting the time from both servers - they *might be* different by a few
seconds. </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=756152718-26012004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2>Tom Mercadante</FONT> <BR><FONT face=Arial
size=2>Oracle Certified Professional</FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Ashish Sahasrabudhe
[mailto:asahasrabudhe_at_weightwatchers.com]<BR><B>Sent:</B> Monday, January 26,
2004 11:14 AM<BR><B>To:</B> Multiple recipients of list
ORACLE-L<BR><B>Subject:</B> Getting sysdate across a DB
link<BR><BR></FONT></DIV>
<P><FONT size=2>I'm trying to get the value of SYSDATE on a remote server. I
have a</FONT> <BR><FONT size=2>database link to the server, but I'm not sure
how to force SYSDATE to</FONT> <BR><FONT size=2>be evaluated on the remote
machine.</FONT> </P>
<P><FONT size=2>Following query gives same results, both dates are
same.</FONT> </P>
<P><FONT size=2>select sysdate local_date, remote_date from ( select sysdate
remote_date from dual_at_remote_db)</FONT> </P>
<P><FONT size=2>How can this be done?</FONT> </P>
<P><FONT size=2>Thanks</FONT> </P></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C3E43B.41344E7A--
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: thomas.mercadante_at_labor.state.ny.us Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Jan 26 2004 - 12:34:24 CST
![]() |
![]() |