UNIX Timestamps and Search Condition Operators
TLDR Eshwar asked about using <= >= operators for a date field search option. Jason confirmed the operators but asked for curl commands to replicate the issue.
Aug 15, 2023 (1 month ago)
Eshwar
02:22 PMWe are storing the date in unixtimestamp as the documentation suggested. Are
<= >= right operators to use for the above use case? Because, its not working; I am wondering if we are missing something.
Jason
02:53 PMJason
02:53 PMEshwar
05:40 PM
Typesense
Indexed 2779 threads (79% resolved)
Similar Threads
Handling Multiple Dates Search with Unix Timestamp in Int64
Akashchellakumar asked how to search multiple dates with Unix timestamp in int64. Kishore Nallan suggested inter-field filtering and storing timestamps as array of int64 or strings. Akashchellakumar thanked and agreed to try this method.
Filtering by Unix Timestamps in Typesense
Nathan asked if it's possible to filter using current time in Typesense. Jason confirmed filtering requires generating and passing current unix timestamp from the client.
Handling Sales Prices with Dates in Typesense
Sam inquired about handling sales prices active between two dates in Typesense. Kishore Nallan suggested using fields for sale_price, sale_start, sale_end, and a daily cron job to update prices. They discussed how Typesense could potentially support this feature, and Kishore Nallan asked Sam to add this use case to an open issue for prioritization.