#community-help

Converting Firestore Timestamps to Dates in Typesense

TLDR Andrew asked about converting Firestore integer timestamps in Typesense back to dates. Jason and Kishore Nallan confirmed they're unix timestamps and suggested using a date formatting library.

13mo

Join the chat

Nov 07, 2022 (13 months ago)

Photo of md5-7766f890de99fa72a6d81315691a6758

Andrew

05:53 AM

I noticed that when syncing firebase to typesense, timestamps from firestore are converted to integers. Is there any way to convert them back to a date clientside?

Photo of md5-c7ebbbcac16a1763e16d0e8e8177b0ae

Jason

06:04 AM

Are these not unix timestamps?

06:04

Jason

06:04 AM

I expect they are, if so, converting back should be straight forward.

Photo of md5-4e872368b2b2668460205b409e95c2ea

Kishore Nallan

08:26 AM

Yes, Typesense does not have a date/time type so timestamps are stored as unix timestamp in int64 type. You can use any date formatting library to format it.

Typesense

Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI

Indexed 3015 threads (79% resolved)

Join Our Community

Similar Threads

Discussing Firebase Extension and Timestamp Implementation.

Loic enquired about timestamp inf Firebase implementation. Jason confirmed it's supported and shared the extension version, its functionality, and where the conversion happens. Loic planned to test this.

20mo

Current server timestamp retrieval in Typesense

Loic inquired about obtaining current server timestamp with Typesense. Jason said it's not possible with Typesense but backend could be used to get it. Loic explains his requirement is to sync app users with server timestamp to prevent accessibility and security issues.

20mo

Resolving Typesense Cloud and Firebase Timestamp Error

Eoin faced an issue with Firebase timestamp when setting up Typesense Cloud. Jason suggested converting timestamps to Unix and sync them as int64 fields in Typesense.

25mo