Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Get the time from remote server

Re: Get the time from remote server

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 10 Feb 2006 11:28:37 -0500
Message-ID: <8M6dnQo1zcuqInHeRVn-uQ@comcast.com>

"ianal Vista" <ianal_vista_at_hotmail.com> wrote in message news:Xns976644E326832ianalvistahotmailcom_at_70.169.32.36...
: "Häkan Latva" <kalle_at_nospam.com> wrote in news:nqWGf.21344$Nb2.381900
: @news1.nokia.com:
:
: > Hi all,
: >
: > I have an access to remote database via db link.
: >
: > How I can get the time what is on that server, is there any solution...
: >
: > rgds
: > kari
: >
: >
: >
:
: select sysdate from dual_at_remote;

nope. sysdate is evaluated locally

02/10/2006 11:25:11 AM -- select connected directly to remote
02/10/2006 11:26:04 AM -- select from local
02/10/2006 11:26:04 AM -- select from local_at_remote

try it.

++ mcs Received on Fri Feb 10 2006 - 10:28:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US