Graphql send data to the last of its row on its update even though it's being sorted (date) in the Gatsby

[yashvekaria]

I am not able to follow why graphql sends the changed data to the last element of its array even though it's being sorted on the published_at date and order DESC in the gatsby project.

Steps to reproduce (see mysqlId:20)

If I clear the cache its will sort correctly

Now I change the title of mysqlID 20 record from MySQL db and rerun the build or development server, then it will send that record to the last, which should not be the case.

But If I do the same sorting with mysqlId then it's working correctly.

Please guide me to resolve this issue, is this happening because of the given date format or some other reason?