Re: CREATE OR REPLACE FUNCTION problem

From: Chepurnykh <chepurnykh_at_gmail.com>
Date: Wed, 30 Jun 2010 04:33:21 -0700 (PDT)
Message-ID: <05718c10-823a-4780-8730-35f6e622c1cd_at_i31g2000yqm.googlegroups.com>

Thank you :-)
Just fixed it. INTO was in a wrong place.

CREATE OR REPLACE FUNCTION CURRENT_UNIXTIME_UTC_SEC RETURN number IS

   xt number;
BEGIN
 SELECT (d * (24*60*60) + h * (60*60) + (m * 60) + s) as unix_time into xt
FROM (
SELECT to_number(rtrim(substr(dt, 2, instr(dt, ' ')-1))) d,

    to_number(substr(dt, instr(dt, ' ')+1, 2)) h,
    to_number(substr(dt, instr(dt, ':')+1, 2)) m,
    to_number(substr(dt, instr(dt, '.')-2, 2)) s,

    dt
FROM ( SELECT to_char(dt) dt
FROM (
SELECT (
    sys_extract_utc(current_timestamp) - TO_TIMESTAMP('01.01.1970','DD.MM.YYYY')) dt FROM dual

    )));
RETURN xt;
EXCEPTION
WHEN OTHERS THEN
      raise_application_error(-20777,'An error encountered - '|| SQLCODE||' ERROR: '||SQLERRM);
END; On 30 июн, 15:26, gazzag <gar..._at_jamms.org> wrote:
> What error are you receiving?
>
> HTH
> -g
Received on Wed Jun 30 2010 - 06:33:21 CDT