As you know, MySQL 8.0 can be used as JSON Document Store to store your documents without being linked to any schema. You can also use CRUD operations to deal with these documents using the MySQL X DevAPI.
Of course in documents, it’s possible to also store temporal attributes like date, time, datetime, …
Let’s see how we can deal with such attributes.
This is an example of a collection of documents with a datetime
As those attributes don’t have a real type, can we use the
createdOn attribute as if it was a real datetime
Let’s try to get all the documents have a created data
We can see that the document “dave” has been filtered out. However, we can see that “kenny” and “miguel” are also present… and this is correct as …[Read more]