#community-help

Sorting "datetime" with Typesense

TLDR em1nos asked about sorting "datetime" type in Typesense. Kishore Nallan suggested storing it as an int64 value.

Powered by Struct AI

1

Aug 01, 2021 (30 months ago)
em1nos
Photo of md5-f33ae8b829901656b655c985c894be3a
em1nos
11:48 AM
sorting a "datetime" .. I guess we need to store it as a unix timestamp to be able to sort it?
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
11:49 AM
Correct. Typesense does not have a datetime type, so you have to store it as a int64 value.
em1nos
Photo of md5-f33ae8b829901656b655c985c894be3a
em1nos
11:49 AM
thanks

1