Datetime not sorting using the SQL over partition

Hey everyone,

I will greatly appreciate any idea how to deal with this issue in dremio, The order by in the partition is not sorting correctly in dremio

The outcome of the query below in dremio is returning not the latest date. It worked well when I used it with sample Taxi data in dremio, I really can tell why it is not sorting this data correctly

This is my outcome I ran same query in SQL Server with the same data and the outcome is correct.

I any clue will be greatly appreciated.

Thank you,
Samson Eromonsei

@iskidet We would like to see what query was sent to SQL server, would you be able to share the query profile so we can check?