It seems you will need to create a view or function at the remote db
that returns the remote sysdate, you then query that remote view or
function. Kind of a hassle for a simple task, no?
spamdump_at_nospam.noway.nohow (Ed Stevens) wrote in message news:<3d8a1cd5.79531340_at_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.
Received on Fri Sep 20 2002 - 12:58:52 CDT
