Re: about SYSDATE function

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 31 Mar 2001 15:58:43 +0100
Message-ID: <986053458.11410.0.nnrp-02.9e984b29@news.demon.co.uk>

If you look in standard.sql you will find that there is a lot of new date/time functionality defined - BUT NOT YET SUPPORTED !

The need to 'select sysdate from dual' is to ensure that the server-side date/time is returned. The new features will also allow you to return client-side date/time.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html





>(off topic) one things that's been touted for 8.1.7.1 and above is that

>calls to sysdate in PL/SQL no longer generated a nasty 'select sysdate

>from dual'

>

>Yet to be proven or disproven

>--

>===========================================

>Connor McDonald

>http://www.oracledba.co.uk (mirrored at

>http://www.oradba.freeserve.co.uk)

>

>"Some days you're the pigeon, some days you're the statue"

Received on Sat Mar 31 2001 - 08:58:43 CST