打印当前日期: SELECT NOW(); datetime转Date SELECT CONVERT(NOW(), DATE); datetime转字符 SELECT CONVERT(NOW(),char); datetime直接转日期格式的字符 方法1: SELECT CONCAT(CONVERT (Now(), DATE), ""); 方法2: SELECT DATE_FORMAT(NOW(),"%Y-%m-%d");