How to use toDate() on Firestore.FieldValue.Timestamp?

Question

I'm trying to populate a table from a firestore database which has field value timestamp data:

with the following code for web:

firebase.initializeApp(firebaseConfig);

const attendanceCollection = firebase.firestore().collection("attendance");

var lastIndex = 0;

function getData() {
    var htmls = [];
    attendanceCollection.get().then(querySnapshot => {    
        querySnapshot.forEach(doc => {

            console.log(`${doc.id}`);
            console.log(`${(doc.data().GENERALASSEMBLY)}`)

            htmls.unshift('<tr>\
                <td>'+ `${doc.id}` +'</td>\
                <td class="message" style=" text-overflow: ellipsis">'+ `${(doc.data().GENERALASSEMBLY)}` +'</td>\
                <td style="overflow: hidden; text-overflow: ellipsis">'+ `${doc.id}` +'</td>\
            </tr>');
        });
        $('#tbody').html(htmls);
    $("#submitUser").removeClass('desabled');
    });

};

which returns this:

I've found some references but never actually helped me solve what I'm trying to make:

How to get a JavaScript Date object from the new `firebase.firestore.FieldValue.serverTimestamp()`

How do I convert a Firestore date/Timestamp to a JS Date()?

how do I implement the toDate() in my code above? can you give me samples of using toDate() on converting firestore timestamps to date/string?

Did you try calling `toDate()` on `doc.data().GENERALASSEMBLY`? — Doug Stevenson, Aug 31 '19 at 17:05
what do you get from the console log of doc.data().GENERALASSEMBLY ? Is it an object with second and nanosecond properties? — chrismclarke, Aug 31 '19 at 18:53

score 2 · Accepted Answer · answered Aug 31 '19 at 18:58

2

You'll need to call toDate() on the GENERALASSEMBLY field to get its value as a date. And since the field will initially be null when the first event fires, you also need to detect if GENERALASSEMBLY is null first.

${(doc.data().GENERALASSEMBLY ? doc.data().GENERALASSEMBLY.toDate() : "-unknown-")}

answered Aug 31 '19 at 18:58

Frank van Puffelen

565,676
79
828
807

thanks! that worked, may I know what is the : "-uknown-" for? – Efren Pineda Aug 31 '19 at 20:54
It's just what to print when there's no date. Yo can replace it with whatever works for your use-case. – Frank van Puffelen Aug 31 '19 at 22:46

score 1 · Answer 2 · answered Oct 22 '19 at 15:57

1

if you are using the library date-fns remember that it is unix time so fromUnixTime(GENERALASSEMBLY.seconds)

then you can just use the format and parse the fromUnixTime

format(fromUnixTime(GENERALASSEMBLY.seconds))

answered Oct 22 '19 at 15:57

Cyrus Zei

2,589
1
27
37

How to use toDate() on Firestore.FieldValue.Timestamp?

2 Answers2