sql读入日期总是有时间00:00:00的显示，如何只显示日期

Question

SELECT CONVERT(varchar(10),y.日期,120) FROM yang2 as y;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(10),y.日期,120) FROM yang2 as y' at line 1

照网上的错了

Answer 1

你的字段是什么类型。是日期类型还是字符串。