DATE_FORMAT(date,format);
例子:
select id, DATE_FORMAT(time, '%Y-%m-%d %H:%i:%s') as time from tb_test;
sql时间格式化
最新推荐文章于 2024-04-10 19:41:45 发布
DATE_FORMAT(date,format);
例子:
select id, DATE_FORMAT(time, '%Y-%m-%d %H:%i:%s') as time from tb_test;