Bug: Dates not sorting properly

[cwolcott]

Describe the bug

Describe the bug
Date columns in Oracle are not sorting properly in SQLPro Studio when using the column to sort.

To Reproduce
Steps to reproduce the behavior:

1. select columns from a table with DATES without an ORDER BY
2. Click on the DATE column to sort DESC
3. The dates will not be sorted correctly

Expected behavior
To have dates sorted appropriately.

Screenshots
If I execute the query SELECT * FROM MOLMAN.USERS; and then manually sort the INACTIVATED column using SQLPro the results are incorrect.

Here is the table definition for USERS.

If I execute the query SELECT * FROM USERS ORDER BY INACTIVATED DESC; the results for the INACTIVATED column are (nulls first and then the dates order appropriately)

Product

SQLPro Studio

App version

Version 2026.102 (Build 111227)

Platform

macOS

Installation source

Other