| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 - 12:40:07 CST
 |
 |