Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!p79g2000cwp.googlegroups.com!not-for-mail From: "alesk" Newsgroups: comp.databases.oracle.server Subject: Re: How to get ORACLE Server Date, not local PC Date? Date: 7 Jul 2006 06:21:51 -0700 Organization: http://groups.google.com Lines: 11 Message-ID: <1152278511.467815.43360@p79g2000cwp.googlegroups.com> References: <1152210477.335697.232010@s26g2000cwa.googlegroups.com> NNTP-Posting-Host: 70.55.250.5 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1152278516 32158 127.0.0.1 (7 Jul 2006 13:21:56 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 7 Jul 2006 13:21:56 +0000 (UTC) In-Reply-To: User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: p79g2000cwp.googlegroups.com; posting-host=70.55.250.5; posting-account=Lc4Nww0AAAAhzUhZY8yvaK-nBdrqLNxh Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:270564 meathammer wrote: > alesk wrote: > > I'm trying to get the server date, but sysdate or any date function > > returns the date of my PC ... is there any way to get this? > > ummm is this db by any chance running on your little PC ? Yeah ... So much databases, didn't think to check on which one I was testing ... :S