Re: How to get ORACLE Server Date, not local PC Date?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 6 Jul 2006 20:38:21 +0200
Message-ID: <44ad589d$0$12749$626a54ce@news.free.fr>

"alesk" <find_who_at_hotmail.com> a écrit dans le message de news: 1152210477.335697.232010_at_s26g2000cwa.googlegroups.com...
| Hi,
|
| 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?
|
| Alesk
|

From doc.
<quote>
SYSDATE returns the current date and time set for the operating system on which the database resides. </quote>

Regards
Michel Cadot Received on Thu Jul 06 2006 - 13:38:21 CDT

This message: [ Message body ]
Next message: Sybrand Bakker: "Re: Req- Oracle CRM Functional Consultant at Hoffman Estates, IL"
Previous message: DA Morgan: "Re: Moving a single instance 9.2.0.7 database to a clustered 9.2.0.6 database environment"
In reply to: alesk: "How to get ORACLE Server Date, not local PC Date?"
Next in thread: Vladimir M. Zakharychev: "Re: How to get ORACLE Server Date, not local PC Date?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US