本DATE_FORMAT(DateColumn)
必须在SELECT
列表:
SELECT DATE_FORMAT(date, '%Y-%m-%dT%TZ') AS date_formatted
FROM table_name
ORDER BY id DESC
在MySQL SELECT中将日期格式化为ISO 8601
本DATE_FORMAT(DateColumn)
必须在SELECT
列表:
SELECT DATE_FORMAT(date, '%Y-%m-%dT%TZ') AS date_formatted
FROM table_name
ORDER BY id DESC