Events at same second sorting incorrectly. Any way to go smaller than seconds in date_format?
Content
Hi,
I've found when reporting on the chat_events table & sorting output by chat_events.created that two posts with the same second can be shown out of order.
The documentation doesn't say if it's possible to display tenths or hundredths of a second using the date_format function.
Could anyone suggest a solution to this please? It's not a table where each record has its own ID that could be sorted by to resolve the problem (i.e. the way you could correctly sort two chats created in the same second by sorting on chats.chat_id).
Thanks
Tagged:
0