把日期类型数据转为字符串:
mysql:
SELECT
DATE_FORMAT(NOW(), '%d %m %Y') AS your_date;
SQL:
SELECT * FROM USER WHERE CONVERT(VARCHAR(10),registerTime,121)
相关链接: sqlserver convert链接
把日期类型数据转为字符串:
mysql:
SELECT
DATE_FORMAT(NOW(), '%d %m %Y') AS your_date;
SQL:
SELECT * FROM USER WHERE CONVERT(VARCHAR(10),registerTime,121)
相关链接: sqlserver convert链接