| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Sysdate from remote database
Hi!
I have small problem. I'd like to call sysdate from
remote database. I have two databases (DB1 and DB2) and
database link from DB2 to DB1. Assume that time in DB1 is
10:45 and time in DB2 is 10:50. I connect to database DB2
and query:
select to_char(sysdate, 'HH24:MI') from dual;
It returns 10:50.
select to_char(sysdate, 'HH24:MI') from dual_at_db1;
It returns 10:50 too.
Calling "select to_char(sysdate_at_db1, 'HH24:MI') from dual" doesn't work. Received on Thu Apr 06 2000 - 01:31:55 CDT
 |
 |