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@xxxxxxxxxxxxxxx [mailto:Andreas.Haunschmidt@xxxxxxxxxxxxxxx] Sent: Wednesday, March 10, 2004 12:43 PM To: oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Bricklen Anderson Sent: Wednesday, March 10, 2004 7:21 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: get UTC date in Oracle 7.3.4
Andreas.Haunschmidt@xxxxxxxxxxxxxxx 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------