# Converting timestamp on audit log for MongoDB

**URL:** <https://forums.percona.com/t/converting-timestamp-on-audit-log-for-mongodb/11616>\
**Category:** MongoDB® General Discussion\
**Created:** [August 1, 2021, 10:26pm UTC](https://forums.percona.com/t/converting-timestamp-on-audit-log-for-mongodb/11616 "2021-08-01T22:26:03Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![dan.mbtc](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/dan.mbtc/32/3006_2.png) [@dan.mbtc](https://forums.percona.com/u/dan.mbtc)\
**Post date:** [August 1, 2021, 10:26pm UTC](https://forums.percona.com/t/converting-timestamp-on-audit-log-for-mongodb/11616/1 "2021-08-01T22:26:03Z")

</div>

Hi and good day,

I’m kind of new and still learning on database administration for mongodb , just wanted to ask on how to convert the timestamp on the auditlog. I’m getting a value of a numberLong type. See sample below

```
"ts": {
	"$date": {
		"$numberLong": "1600617670673"

```

---

<div class="post-metadata">

**Author:** ![Sergey\_Pronin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sergey_pronin/32/14887_2.png) [@Sergey\_Pronin](https://forums.percona.com/u/Sergey_Pronin)\
**Post date:** [August 2, 2021, 7:30am UTC](https://forums.percona.com/t/converting-timestamp-on-audit-log-for-mongodb/11616/2 "2021-08-02T07:30:51Z")

</div>

Hello @dan.mbtc ,

I have moved the topic to MongoDB General Discussion forum as it is not Operator related. More luck to get some answers there.  
I will check with the team if anyone can assist you soon.

---

<div class="post-metadata">

**Author:** ![dan.mbtc](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/dan.mbtc/32/3006_2.png) [@dan.mbtc](https://forums.percona.com/u/dan.mbtc)\
**Post date:** [September 7, 2021, 7:48am UTC](https://forums.percona.com/t/converting-timestamp-on-audit-log-for-mongodb/11616/3 "2021-09-07T07:48:46Z")

</div>

Hi , anyone can help me on this ? thanks

---

<div class="post-metadata">

**Author:** ![Vijay\_Kumar](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vijay_kumar/32/4145_2.png) [@Vijay\_Kumar](https://forums.percona.com/u/Vijay_Kumar)\
**Post date:** [September 7, 2021, 1:23pm UTC](https://forums.percona.com/t/converting-timestamp-on-audit-log-for-mongodb/11616/4 "2021-09-07T13:23:00Z")

</div>

> **[Log Messages — MongoDB Manual](https://www.mongodb.com/docs/manual/reference/log-messages/)**

> **[Log Messages — MongoDB Manual](https://www.mongodb.com/docs/manual/reference/log-messages/)**

---

<div class="post-metadata">

**Author:** ![dan.mbtc](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/dan.mbtc/32/3006_2.png) [@dan.mbtc](https://forums.percona.com/u/dan.mbtc)\
**Post date:** [September 8, 2021, 3:46am UTC](https://forums.percona.com/t/converting-timestamp-on-audit-log-for-mongodb/11616/5 "2021-09-08T03:46:48Z")

</div>

thank you for the reply sir , will this also cover the auditlog ? base from the article it only covers for systemlog messages .