I can't get timestamp from Firestore (only when I use a table component)

[alexanderchw]

Hi, I'm newbie in Retool so maybe the answer is easy:

When I see the fields of my document in Firestore I can see the timestamp data:

But when I try to see it in Retool, I don't get the timestamp, only some data I don't know where it comes from (seconds and nanoseconds).

By the way, I can see the timestamp when I get the list of documents inside a table, and I'm also able to update the timestamp using, for example "moment()", but still can't read the timestamp in text inputs components or date/time components, not even in jsonEditor.
Thanks!

[Tess]

Hi @alexanderchw Thanks for reaching out. I believe this is a bug that we're looking into.

We've seen this happen with get document by id queries:

But we don't see this happening in query Firestore queries:

The timestamp in seconds, nanoseconds should reflect the time portion of the full timestamp:

[Tess]

Does this match what you are seeing on your side? Are you able to use the Query Firestore type?

[Tess]

Hi All,

The fix for the bug referenced above will ship to Cloud this week (it should ship to an upcoming on-premise release roughly 3 weeks after)

[yuvalfijoya]

Hey @Tess and others

This bug still occurs when using a firestore querie's raw mode and not the GUI mode. The date is not returned - instead we get only an object representing the time as above (exactly the same as above). Please advise and help, thanks!

[yuvalfijoya]

[yuvalfijoya]

Please help guys...

[Tess]

Hi @yuvalfijoya,

Thanks for reaching out! I am seeing this too -

It looks like the Firestore sdk supports .toDate():

[yuvalfijoya]

Thank you! I assume that in your GUI option you guys automatically call toDate on dates behind the scenes?

I would recommend explaining this to users somehow or showing something about this in the docs - because I use firestore in nodejs, in a mobile application and also in a web application and I have never encountered the need to do this on dates I receive

[yuvalfijoya]

Btw @Tess

This method doesnt work if you try to do it in a transformer - you have to do it in the query itself before it gets to a transformer - which also seems like a bug to me. Something weird..

[Tess]

Hi @yuvalfijoya,

It is expected that it wouldn't work in a transformer, since you can only put Javascript code there. If you want to handle the Firestore timestamp format in a transformer, you could use new Date or moment: