Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Get the time from remote server
"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