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 ...

Figure 4: Correct Date Format with “dd/mm/yy” British/French date style Example 2: Sometimes, string-to-date conversion in SQL Server results in an error, not because of the date or time formats used, ...