CREATE FUNCTION hello()
RETURNS VARCHAR(255)
BEGIN
RETURN 'Hello world,i am mysql';
END
DROP FUNCTION IF EXISTS formatDate
CREATE FUNCTION formatDate(fdate datetime)
RETURNS VARCHAR(255)
BEGIN
DECLARE x VARCHAR(255) DEFAULT '';
SET x= date_format(fdate,'%Y年%m月%d日%h时%i分%s秒');
RETURN x;
END
SELECT formatDate(now());
http://www.cnblogs.com/zhangminghui/p/4113160.html