Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> system values and remote databases
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