How can I get the time from an other database using database links?

Those 2 queries are returning the same results even if the second database is using a different time zone. select to_char(sysdate,'HH:MI:SS') from dual; select to_char(sysdate,'HH:MI:SS') from dual_at_ACCP;

I could use the NEW_TIME function to do the conversion, but can I determine the right time zones to use automatically?

Thank! Received on Fri Oct 08 1999 - 10:39:30 CDT