mysql实现db2函数_DB2实现部分mysql函数

--------------------------------------------------------------------------

--

-- DB2 UDF(User-Defined Function) CURRENT_DATE

--

-- 2010/02/03

--

-- Name of UDF: CURRENT_DATE ( )

--

-- Used UDF: None

--

-- Description: Returns current date.

--

-- Author: Woody

--

--------------------------------------------------------------------------

CREATE FUNCTION "CURRENT_DATE" ( )

RETURNS DATE

NO EXTERNAL ACTION

------------------------------------------------------------------------

-- SQL UDF (Scalar)

------------------------------------------------------------------------

BEGIN ATOMIC

RETURN SELECT CURRENT_DATE FROM SYSIBM.DUAL;

END

@

--------------------------------------------------------------------------

--

-- DB2 UDF(User-Defined Function) CURDATE

--

-- 2010/02/03

--

-- Name of UDF: CURDATE ( )

--

-- Used UDF: None

--

-- Description: Returns current date.

--

-- Author: Woody

--

--------------------------------------------------------------------------

CREATE FUNCTION CURDATE ( )

RETURNS DATE

NO EXTERNAL ACTION

------------------------------------------------------------------------

-- SQL UDF (Scalar)

------------------------------------------------------------------------

BEGIN ATOMIC

RETURN SELECT CURRENT DATE

FROM SYSIBM.DUAL;

END

@

--------------------------------------------------------------------------

--

-- DB2 UDF(User-Defined Function) DATE_FORMAT

--

-- 2010/02/03

--

-- Name of UDF: DATE_FORMAT ( P_TS, P_FMT )

--

-- Used UDF: None

--

-- Description: Format a timestamp value per the given format text.

--

-- Author: Paul Yip (ypaul@ca.ibm.com)

--

-- Note: This function was based on the function of site

-- "http://www.ibm.com/developerworks/data/library/techarticle/0211yip/0211yip3.html"

--------------------------------------------------------------------------

CREATE FUNCTION DATE_FORMAT ( P_TS TIMESTAMP, P_FMT VARCHAR(50) )

RETURNS VARCHAR(50)

NO EXTERNAL ACTION

DETERMINISTIC

LANGUAGE SQL

------------------------------------------------------------------------

-- SQL UDF (Scalar)

-- P_TS

-- P_FMT

------------------------------------------------------------------------

BEGIN ATOMIC

RETURN

WITH TMP (DD,MM,YYYY,HH,MI,SS,NNNNNN) AS

(

SELECT

SUBSTR( DIGITS (DAY(P_TS)),9),

SUBSTR( DIGITS (MONTH(P_TS)),9) ,</