Path: news.easynews.com!newsfeed1.easynews.com!newsfeed2.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer01.lnd.ops.eu.uu.net!emea.uu.net!news2.euro.net!postnews1.euro.net!maya.euronet.nl!not-for-mail From: Jaap W. van Dijk Newsgroups: comp.databases.oracle.server Subject: Re: Getting sysdate across a DB link Date: Mon, 03 Mar 2003 21:00:49 +0100 Message-ID: References: <182bcf76.0302280853.71aed8f0@posting.google.com> <7hs46vk3i7emco4eu2ficp5236ammnb6lk@4ax.com> <3E628E0E.AA8DB6B7@exesolutions.com> X-Newsreader: Forte Free Agent 1.92/32.572 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 33 Organization: EuroNet Internet NNTP-Posting-Date: 03 Mar 2003 19:56:48 GMT NNTP-Posting-Host: i0642.vwr.wanadoo.nl X-Trace: 1046721408 maya.euronet.nl 23902 194.134.210.133:1123 X-Complaints-To: abuse@euronet.nl Xref: newsfeed1.easynews.com comp.databases.oracle.server:178298 X-Received-Date: Mon, 03 Mar 2003 12:56:42 MST (news.easynews.com) On Sun, 02 Mar 2003 15:04:47 -0800, DA Morgan wrote: ... >> If nothing helps, let's read the manual: >> >> 'SYSDATE returns the current date and time. Requires no arguments. In >> distributed SQL statements, this function returns the date and time on >> your local database.' >> >> (from the 8i SQL Reference Manual). >> >> Jaap. > >He knows that. He is trying to get the time from the other machines. > >With respect to your previous post ... get_time can not be used to get what >he needs. > >Daniel Morgan If the OP tries to get the remote time by issueing select sysdate remote from dual@t then I assume he *doesn't* know that SYSDATE returns the local time, even when used as a pseudo-column of a remote table. I'm curious: why can get_time not be used? I guess it is because the epoch is arbitrarily set when a database is started and is not equal for different databases? Jaap.