- oracle中add_months、to_date、to_char、nvl
- 对应mysql中自定义的函数:
- CREATE FUNCTION add_months( expr varchar(50),mon integer)
- RETURNS date
- BEGIN
- RETURN date_add(expr,interval mon month);
- END;
- CREATE FUNCTION to_date( gdate varchar(50),dateform varchar(50))
- RETURNS date
- BEGIN
- IF DATEFORM='yyyy-mm-dd' THEN
- RETURN (SELECT DATE_FORMAT(GDATE,'%Y-%m-%d'));
- ELSEIF DATEFORM='yyyy-mm-dd hh24:mi:ss' THEN
- RETURN (SELECT DATE_FORMAT(GDATE,'%Y-%m-%d-%T'));
- END IF;
- END;
- CREATE FUNCTION to_char(GDATE datetime,DATEFORM varchar(50))
- RETURNS varchar(50)
- BEGIN
- DECLARE NUM VARCHAR(50) DEFAULT '';
- IF DATEFORM='yyyy-mm-dd' THEN
- SET NUM=DATE_FORMAT(GDATE,'%Y-%m-%d');
- RETURN NUM;
- ELSEIF DATEFORM='yyyy-mm-dd hh24:mm:ss' THEN
- SET NUM=DATE_FORMAT(GDATE,'%Y-%m-%d-%T');
- RETURN NUM;
- END IF;
- END;
- CREATE FUNCTION nvl(expr1 varchar(50),expr2 varchar(50))
- RETURNS varchar(50)
- BEGIN
- RETURN IFNULL(expr1,expr2);
- END
- --该片段来自于http://www.codesnippet.cn/detail/2906201614748.html
来源: http://www.codesnippet.cn/detail/2906201614748.html