I retrieved from the database of time such as the 2021-03-30 00:00:00 but I now want to cut off the minutes to the 2021-03-30
what to do?
I wrote this
Select the convert (char (10), Margaret spellings JYSSJ, 120) AS sj FROM t_xmgl_jfgl_project_main m complains

CodePudding user response:

DATE_FORMAT

CodePudding user response:

Select the DATE (Margaret spellings JYSSJ) AS sj FROM t_xmgl_jfgl_project_main m