Re: GMT to Local Time conversion

Article View: comp.databases.oracle.misc

Article #143

Back to comp.databases.oracle.misc Previous Next

#143

From: Peter Moore
Date: Tue, 26 Aug 1997 00:00

25 lines
1920 bytes

"Mike Morgan" <mmorgan1@mail.tds.net> wrote:

> 3)	Use the NEW_TIME() function to convert GMT to local time

> Hugo Baake <hbbaake@pi.net> wrote in article

> > I've got a number representing date/time information, stored in seconds,
> > based upon 01-JAN-1970. This number is in GMT.
> > Can anybody tell me how I can convert this number (in PL/SQL or SQL*Plus)
> > to the local time (corrected for timezone and daylight saving time, the
> > same functionality as the localtime() function in C.)?

Except, of course, that this will only work if you happen to be based
in the continental U.S.  Oracle's customers outside the U.S. aren't
allowed to make use of this function!

Thanks then, Oracle.  Maybe we should be paying less in Europe for
Oracle's services if they can't give us full functionality...

PT
--
Peter Moore
DBA, IS Ops, Sequent Computer Systems, Weybridge, UK
Email: ptmoore@sequent.com   Phone: +44 1932 814737

Technical Details

Message-ID: <34029860.252801488@news.sequent.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <01bcb17c$ad51c6d0$05c809c0@nt4server1> <01bcb1cb$5583a6e0$4906f6cc@madison.tdsnet.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fb53f,fb10078410139223
X-Google-Attributes: gidfb53f,public
X-Google-Thread: fa4f9,fb10078410139223
X-Google-Attributes: gidfa4f9,public
X-Google-Thread: f99a8,fb10078410139223
X-Google-Attributes: gidf99a8,public
X-Google-Thread: f5464,fb10078410139223
X-Google-Attributes: gidf5464,public
X-Google-Thread: 10747e,fb10078410139223
X-Google-Attributes: gid10747e,public
From: ptmoore@sequent.com (Peter Moore)
Subject: Re: GMT to Local Time conversion
Date: 1997/08/26
Message-ID: <34029860.252801488@news.sequent.com>
X-Deja-AN: 268578377
Sender: ptmoore@sequent.com
References: <01bcb17c$ad51c6d0$05c809c0@nt4server1> <01bcb1cb$5583a6e0$4906f6cc@madison.tdsnet.com>
Organization: Sequent Computer Systems Ltd
Reply-To: ptmoore@sequent.com
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools,hannover.uni.comp.oracle,relcom.comp.dbms.oracle

Reply to Parent Message