[Django]-Query Limits and Order cannot work together in django

+1 for the details, however it sounds a bit fishy to me that you actually managed to get datetime.datetime.now() to produce the same value and capture the SQL, so please confirm that you actually did pass the same value and that the above SQL’s were actually captured in the log.

As far as the answer goes, I can only address it partially – from the point of SQLs.
The two SQLs will produce the same order when run against the same data.

You can count on that.

So providing that SQL’s do come from the log and that they were run on the same data you are either further manipulating thing on the django side or your testing was not done well.