Azure document DB orderby timestamp field

Question

I have a timestamp field in my each document. the timestamp is in ISODate format. Is there any way i can sort the data using it in Document Explorer or Query Explorer?

Answer 1

Each document has a default timestamp field named '_ts'. You can for instance get last documents with the following query:

SELECT * FROM c ORDER BY c._ts DESC

Answer 2

If you have a full precision (-1) index on your ISO date string field ORDER BY works as expected.