Oracle-L: Re: "Does anybody really know what time it is?"

From: <Jared.Still_at_radisys.com>
Date: Thu, 28 Feb 2002 16:53:22 -0800
Message-ID: <F001.0041C17C.20020228165322@fatcity.com>

I seem to recall some other listers saying that you could do this in 9i. I'm not 9i literate myself yet, but you may want to take a look.

Don't this can be done in 8i, given your requirements.

Jared

"Orr, Steve" <sorr_at_rightnow.com>
Sent by: root_at_fatcity.com
02/28/02 02:56 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        "Does anybody really know what time it is?"

I want to get the UTC (Coordinated Universal Time) from the database without
having to escape to the O/S or write a stored proc. I want to get this time
in GMT epoch seconds without needing to know what timezone the server is in.
Can't find any Oracle supplied package for this and I'm appalled.

My current medulla oblongata init.ora setting is clues = 0.

Suggestions?

Steve Orr
Bozeman, MT
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Orr, Steve
INET: sorr_at_rightnow.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------