Current Timestamp over DB Link

Your idea is excellent! I searched dba_arguments for a function name that 
sounds promising and found KUPF$FILE.GET_FORMATTED_TIME. The good thing about 
it is that the package is used for data pumps so there's no license 
restriction. Here's a test to find local time and remote time. I deliberately 
changed the remote system time to slightly off for easy observation:

SQL> select sys.KUPF$FILE.GET_FORMATTED_TIME, sys.KUPF$FILE.GET_FORMATTED_TIME@yongtest from dual;

GET_FORMATTED_TIME
------------------------------
GET_FORMATTED_TIME
------------------------------
09:41:28.702
09:40:22.634

Obviously this function is undocumented. Every upgrade requires review of your 
code if you do use it in production.

Yong Huang

Tanel Poder wrote:

> What about some existing function like this one? (You'd need to grant exec
> access to it and as it's a SQLTUNE one, it probably needs tuning pack
> license too):
> SQL> SELECT sysdate, sys.dbms_sqltune_util1.get_current_time local_time,
> sys.dbms_sqltune_util1.get_current_time@sol121 remote_time FROM dual;
> 
> SYSDATE          LOCAL_TIME        REMOTE_TIME
> ----------------- ----------------- -----------------
> 20140621 22:41:36 20140621 22:41:35 20140617 13:52:36
> 
> 
> But there may be more existing functions like this one out there...

http://www.freelists.org/post/oracle-l/Current-Timestamp-over-DB-Link,8