mysql 日期显示两位年,数字保留两位小时



create_time是timestamp格式

select substr( date(create_time),3, 8) as create_time, cast(income AS DECIMAL (10, 2)) as income from XXX_table
原文地址:https://www.cnblogs.com/yuzhould/p/13093988.html