Ptt 大爆卦 | JSON_UNQUOTE - 前往 https://stackoverflow.com/questions/39742801/chaining-json-extract-with-cast-or-str-to-date-fails

你即將離開本站

並前往https://stackoverflow.com/questions/39742801/chaining-json-extract-with-cast-or-str-to-date-fails

Chaining JSON_EXTRACT with CAST or STR_TO_DATE fails

You have to use JSON_UNQUOTE select CAST( JSON_UNQUOTE( JSON_EXTRACT(data, "$.new_time")) as DATETIME) from analytics_calendaranalytics ...

確定！回上一頁

查詢「JSON_UNQUOTE」的人也找了：

MySQL JSON_CONTAINS

MySQL JSON Function

MySQL JSON_OBJECT

JSON_ARRAY_APPEND