From oracle-l-bounce@freelists.org Wed Mar 10 13:44:20 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2AJiJl22660 for ; Wed, 10 Mar 2004 13:44:20 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2AJiJo22655 for ; Wed, 10 Mar 2004 13:44:19 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 30C4A395416; Wed, 10 Mar 2004 14:35:32 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 10 Mar 2004 14:34:15 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from presinet-main1.presinet.com (mail.presinet.com [209.53.156.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5FA52395382 for ; Wed, 10 Mar 2004 14:34:10 -0500 (EST) Received: from PresiNET.com (BANDERSON [10.10.1.151]) by presinet-main1.presinet.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id GHPMQC0T; Wed, 10 Mar 2004 11:47:01 -0800 Message-ID: <404F70B5.20109@PresiNET.com> Date: Wed, 10 Mar 2004 11:47:01 -0800 From: Bricklen Anderson User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: en-us, en MIME-Version: 1.0 To: oracle-l@freelists.org Subject: Re: get UTC date in Oracle 7.3.4 References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed X-archive-position: 379 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: BAnderson@PresiNET.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l Likely not, but my input was related to Andreas' comment. Kevin Lange wrote: > They are not available in 8.1.7 so I would doubt they are available in > 7.3.4. > > -----Original Message----- > From: Andreas.Haunschmidt@voestalpine.com > [mailto:Andreas.Haunschmidt@voestalpine.com] > Sent: Wednesday, March 10, 2004 12:43 PM > To: oracle-l@freelists.org > Subject: RE: get UTC date in Oracle 7.3.4 > > > Bricklen, > thanks for your answer. > > In 9.2 it works, so a function > returning the current date in UTC could be: > > CREATE OR REPLACE > FUNCTION UTCSYSDATE > RETURN DATE IS > BEGIN > RETURN to_date(to_char(SYS_EXTRACT_UTC(CURRENT_TIMESTAMP),'YYYY-MM-DD > HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS'); > END; > / > > SELECT UTCSYSDATE FROM DUAL; > > UTCSYSDATE > ------------------- > 2004-03-10 18:38:39 > > > But my collegue has Oracle 7.3.4, I fear, > the functions SYS_EXTRACT_UTC and CURRENT_TIMESTAMP are not available... > > > -----Original Message----- > From: oracle-l-bounce@freelists.org > [mailto:oracle-l-bounce@freelists.org]On Behalf Of Bricklen Anderson > Sent: Wednesday, March 10, 2004 7:21 PM > To: oracle-l@freelists.org > Subject: Re: get UTC date in Oracle 7.3.4 > > > Andreas.Haunschmidt@voestalpine.com wrote: > > >> >> Getting UTC Time in Oracle is still a mess, even in 9.2 there is no > > built > >>in function >> a la UTCSYSDATE... >> >> >>Andreas >> > > sys_extract_utc? > -- Bricklen Anderson, Database Administrator PresiNET Systems http://www.PresiNET.com Online Demo: https://www.presinet.com/secure/login ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------