Enables pushing `ORDER BY` to the server for supported columns, including problematic datetime columns. For these columns, milliseconds are trimmed to align with the server's behavior. Note: When this property is enabled, millisecond precision is lost for problematic datetime columns, even if the query does not include an ORDER BY clause.

Data Type

bool

Default Value

false

Remarks

Default: false – `ORDER BY` is not applied server-side for problematic datetime columns, as the server only supports ordering up to the second (ignoring milliseconds), which can cause inaccurate sorting.

When set to true, the driver applies `ORDER BY` on the server for these problematic datetime columns, trimming milliseconds to align with the server's second-level precision. As a result, millisecond precision is lost in these columns regardless of whether the query specifies an ORDER BY clause.