• Navigation
  • Hauptseite
  • Kochen
  • Kontakt

Oracle

Aus Digitalkultur

Trigger and Functions

UNIX_TIMESTAMP

mimics the corresponding function from MySQL

CREATE OR REPLACE 
FUNCTION UNIX_TIMESTAMP(indate timestamp)
RETURN NUMBER 
IS
  n_result NUMBER;
BEGIN
     SELECT DISTINCT unix_with_cast  INTO n_result
      FROM
      (
        SELECT 
        ROUND (  (  CAST (indate AS DATE)
                 - TO_DATE ('01-01-1970', 'DD.MM.YYYY HH24:MI:SS')
                )
              * 86400,
              0
        ) unix_with_cast
        FROM dual 

      ); 
  RETURN n_result;
END;  

LCASE

mimics the corresponding function from MySQL

CREATE OR REPLACE 
FUNCTION LCASE(ch varchar2) 
RETURN VARCHAR22 
IS 
BEGIN 
  return lower(ch); 
END;