mysql> CREATE FUNCTION date_cn() RETURNS VARCHAR(30)

    -> RETURN DATE_FORMAT(NOW(),'%Y年%m月%d日 %H:%i:%S %Y年第%I周星期%w' )

    -> ;

Query OK, 0 rows affected (0.00 sec)

mysql> SELECT date_cn();

+--------------------------------+

| date_cn()                      |

+--------------------------------+

| 2016?05?05? 18:17:28 2016??06? |

+--------------------------------+

1 row in set, 1 warning (0.04 sec)