由于，人大金倉資料庫kingbase不兼容MySQL資料庫的date_add()函式，要自定義一個，求大神指點！！！
uj5u.com熱心網友回復：
試下：date now() + integer '1'
uj5u.com熱心網友回復：
需求要使用date_add函式，kingbase不兼容，要自己創建一個uj5u.com熱心網友回復：
那就先創建一個函式再呼叫，參考服務器編程->SQL陳述句參考手冊
CREATE FUNCTION
概述
CREATE FUNCTION -- 定義一個新函式
語法格式
CREATE [ OR REPLACE ] [ INTERNAL ] FUNCTION
name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | := } default_expr
] [, ...] ] )
[ { RETURNS | RETURN } rettype
| { RETURNS | RETURN } TABLE ( column_name column_type [, ...] ) ]
{ LANGUAGE lang_name
| TRANSFORM { FOR TYPE type_name } [, ... ]
| WINDOW
| IMMUTABLE | STABLE | VOLATILE | [ NOT ] LEAKPROOF
| CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT
| [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER
| PARALLEL { UNSAFE | RESTRICTED | SAFE }
| COST execution_cost
| ROWS result_rows
| SET configuration_parameter { TO value | = value | FROM CURRENT }
| { AS | IS } 'definition'
| { AS | IS } 'obj_file', 'link_symbol'
} ...
[ WITH ( attribute [, ...] ) ]
兼容Oracle語法：
CREATE [ OR REPLACE ] FUNCTION name ( [ [ argmode ] [ argname ] argtype
[ { DEFAULT | := } default_expr ] [, ...] ] )[{RETURNS | RETURN} rettype ]
[IMMUTABLE | STABLE | VOLATILE | SECURITY INVOKER | SECURITY DEFINER]
{ AS | IS }
{
[ label_name ]
[ DECLARE ]
[ variable_declaration ]
[ cursor_declaration ]
BEGIN
sequence_of_statement
END [ label_name ]
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/283399.html
標籤：應用實例