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
posted @ 2020-06-11 16:21  奥雷连诺  阅读(990)  评论(0编辑  收藏  举报