You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Events at same second sorting incorrectly. Any way to go smaller than seconds in date_format?

Accepted answer
edited May 26, 2020 1:18PM in Reporting & Analytics for B2C Service 2 comments



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). 


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!