# Convert TS to time & date

**URL:** <https://community.glideapps.com/t/convert-ts-to-time-date/40814>\
**Category:** Ask for Help\
**Created:** [April 17, 2022, 6:15pm UTC](https://community.glideapps.com/t/convert-ts-to-time-date/40814 "2022-04-17T18:15:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\
**Post date:** [April 17, 2022, 6:15pm UTC](https://community.glideapps.com/t/convert-ts-to-time-date/40814/1 "2022-04-17T18:15:55Z")

</div>

Hi,

Can anyone achive converting a timestamp to a date and time?

Example: 1625474749.049600 to 12/01/2022 ?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [April 17, 2022, 7:56pm UTC](https://community.glideapps.com/t/convert-ts-to-time-date/40814/2 "2022-04-17T19:56:02Z")

</div>

I’m guessing there’s a JavaScript function for this.

Found this online…try it.

```auto
String date = new java.text.SimpleDateFormat("MM/dd/yyyy HH:mm:ss").format(new java.util.Date( p1 * 1000 ));

return date;

```