Re: Current Timestamp over DB Link

From: Subramanian Kumar <skumar.sen_at_gmail.com>
Date: Wed, 18 Jun 2014 08:15:13 -0400
Message-Id: <56D674F3-5DDD-4860-A745-4DBC4D2A6A2E_at_gmail.com>

Try "select systimestamp, systimestamp_at_dbl from dual"

Senthil

Sent from my iPhone5

> On Jun 18, 2014, at 8:02 AM, Maris Elsins <elmaris_at_gmail.com> wrote:
>
> HI All,
>
> I'm trying to compare the local and remote timestamps to assess the time offset between 2 DBs, but this query gives the local timestamp only:
>
> SQL> select systimestamp local_time, (select systimestamp from dual_at_REMOTE_DB) remote_time from dual;
>
> LOCAL_TIME
> ---------------------------------------------------------------------------
> REMOTE_TIME
> ---------------------------------------------------------------------------
> 18-JUN-14 07.00.06.611471 AM -05:00
> 18-JUN-14 07.00.06.611471 AM -05:00
>
> Can anyone suggest a way to retrieve the current timestamp from a remote DB over DB Link?
>
> ---
> Maris Elsins
> _at_MarisElsins
> www.facebook.com/maris.elsins
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 18 2014 - 14:15:13 CEST