How to sort dates by time when they are sorted alphabetically?

A column of dates may sort in the wrong order because it is improperly typed. Convert the column to timestamp to make it sort properly.

convert string to datetime and sort

Use the parse_timestamp function to convert the string column and the sort function to order from maximum to minimum.

// time arrives in a string column formatted as "03/14/24 20:50:28.057"
make_col time:parse_timestamp(time, "DD/MM/YY HH24:MI:SS.FF3")
sort desc(time)