Re: get UTC date in Oracle 7.3.4

From: Bricklen Anderson <BAnderson_at_PresiNET.com>
Date: Wed, 10 Mar 2004 11:47:01 -0800
Message-ID: <404F70B5.20109@PresiNET.com>

Likely not, but my input was related to Andreas' <CHAGRIN></CHAGRIN> 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_at_voestalpine.com
> [mailto:Andreas.Haunschmidt_at_voestalpine.com]
> Sent: Wednesday, March 10, 2004 12:43 PM
> To: oracle-l_at_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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Bricklen Anderson
> Sent: Wednesday, March 10, 2004 7:21 PM
> To: oracle-l_at_freelists.org
> Subject: Re: get UTC date in Oracle 7.3.4
>
>
> Andreas.Haunschmidt_at_voestalpine.com wrote:
> <snip>
>

>><CHAGRIN>
>>  Getting UTC Time in Oracle is still a mess, even in 9.2 there is no

>
> built
>

>>in function
>>  a la UTCSYSDATE...
>></CHAGRIN>
>>
>>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_at_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
-----------------------------------------------------------------

Received on Wed Mar 10 2004 - 13:44:20 CST