Re: Sysdate from remote database

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 6 Apr 2000 09:33:02 +0200
Message-ID: <8chejl$dcj$1@news2.isdnet.net>

On db1, you can create a view:
create view db1_date as select sysdate db1_date from dual; grant select on db1_date to public;

and then select it on db2:
select db1_date from db1_date_at_db1;

--
Have a nice day
Michel

Marek JóYwik <mjozwik_at_ns1.wonlok.com.pl> a écrit dans le message : MPG.13551add2043574989682_at_news.man.lodz.pl...
> 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 - 02:33:02 CDT