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

Home -> Community -> Usenet -> c.d.o.server -> system values and remote databases

system values and remote databases

From: Ed Stevens <spamdump_at_nospam.noway.nohow>
Date: Thu, 19 Sep 2002 18:56:25 GMT
Message-ID: <3d8a1cd5.79531340@ausnews.austin.ibm.com>


Platform: Oracle 8.1.7 on NT or Win2K

select to_char(sysdate,'yyyy/mm/dd hh24:mi:ss')   from dual_at_db_link_to_a_db2_database;

It works, but it is returning the current date/time from the Oracle server, not from the DB2 system. Rather makes sense, but am wondering if anyone knows of a technique to get the date/time from the remote DB instead of the local -- especially when the remote DB is not Oracle.

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)
Received on Thu Sep 19 2002 - 13:56:25 CDT

Original text of this message

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