# How to convert unix epochtime into human readable format?

**URL:** <https://community.glideapps.com/t/how-to-convert-unix-epochtime-into-human-readable-format/55416>\
**Category:** Ask for Help\
**Created:** [December 5, 2022, 3:13am UTC](https://community.glideapps.com/t/how-to-convert-unix-epochtime-into-human-readable-format/55416 "2022-12-05T03:13:51Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![liam\_putra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/liam_putra/32/46372_2.png) [@liam\_putra](https://community.glideapps.com/u/liam_putra)\
**Post date:** [December 5, 2022, 3:13am UTC](https://community.glideapps.com/t/how-to-convert-unix-epochtime-into-human-readable-format/55416/1 "2022-12-05T03:13:51Z")

</div>

i extracted “created at” data from tiktok and it gave me this 1667906040.

How do convert this into date format ? i’ve tried reading luxon docs but it gave me 20 JAN 1970.

it should have been Tuesday, November 8, 2022 11:14:00 AM

i want it to convert into DATE or some format so i can extract the week.

Thanks !

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 5, 2022, 3:36am UTC](https://community.glideapps.com/t/how-to-convert-unix-epochtime-into-human-readable-format/55416/2 "2022-12-05T03:36:37Z")

</div>

You can use JavaScript.

```auto
if (p2 === undefined) { return undefined; }
let d = new Date(p1);
d.setTime(p2*1000);
return d.toUTCString();

```

 ![Screen Shot 2022-12-05 at 11.33.49 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/6/f6498481d523a6e4ab057ce1d7cf0263404cda1b.png)

---

<div class="post-metadata">

**Author:** ![liam\_putra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/liam_putra/32/46372_2.png) [@liam\_putra](https://community.glideapps.com/u/liam_putra)\
**Post date:** [December 5, 2022, 3:59am UTC](https://community.glideapps.com/t/how-to-convert-unix-epochtime-into-human-readable-format/55416/3 "2022-12-05T03:59:03Z")

</div>

what is the value of “current time” ? is in time only format ?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 5, 2022, 4:10am UTC](https://community.glideapps.com/t/how-to-convert-unix-epochtime-into-human-readable-format/55416/4 "2022-12-05T04:10:41Z")

</div>

![Screen Shot 2022-12-05 at 12.09.59 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/1/9161713731e7941580d1cfac6729327b20c11013.png)

---

<div class="post-metadata">

**Author:** ![liam\_putra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/liam_putra/32/46372_2.png) [@liam\_putra](https://community.glideapps.com/u/liam_putra)\
**Post date:** [December 5, 2022, 4:15am UTC](https://community.glideapps.com/t/how-to-convert-unix-epochtime-into-human-readable-format/55416/5 "2022-12-05T04:15:49Z")

</div>

thanks darren!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [December 6, 2022, 4:15am UTC](https://community.glideapps.com/t/how-to-convert-unix-epochtime-into-human-readable-format/55416/6 "2022-12-06T04:15:59Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.