And according to the documentation about date serialization, this should not change the format used for storing it in the database, only the format used in PHP array/JSON model instances. Steps/flow ...

What is the bug? It seems SQL query engine doesn't honor what's configured in OpenSearch index mapping for date field. This causes problems in different queries with datetime field involved. See ex ...

This article explores the internals of Oracle9i indexing; reviews the standard b-tree index, index-only tables, and how these indexes may increase the speed of Oracle SQL queries.

SQL queries for JSON data The new API provides Oracle users with the ability to run MongoDB data applications on the Oracle Autonomous JSON database and the company’s Autonomous Database cloud ...