The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Working with JSON data

Hello,

We have a database that we send JSON data to and I am trying to work with some of the data but running into some issues. Currently I am using JSON_VALUE which extracts the data as a string but I need to extract a timestamp as datetime I don't currently see a way to accomplish that unless I convert the string to date (STR_TO_DATE) but the timestamp is formatted using the T and Z separators for UTC (ex: 2023-05-10T09:44:01Z)

Is there another way to work around this?

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.