# Api request unix timestamp

**URL:** <https://community.thunkable.com/t/api-request-unix-timestamp/1467381>\
**Category:** Questions about Thunkable X\
**Created:** [August 24, 2021, 10:49pm UTC](https://community.thunkable.com/t/api-request-unix-timestamp/1467381 "2021-08-24T22:49:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![itvelprj](https://avatars.discourse-cdn.com/v4/letter/i/35a633/32.png) [@itvelprj](https://community.thunkable.com/u/itvelprj)\
**Post date:** [August 24, 2021, 10:49pm UTC](https://community.thunkable.com/t/api-request-unix-timestamp/1467381/1 "2021-08-24T22:49:46Z")

</div>

how can i convert this timestamp [https://blockchain.info/stats?format=json](https://blockchain.info/stats?format=json) (162984485300)  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/9/a953a21adc13b736a15039aa8ac10b47fb7f0340.png)  
this just create a new date and time

---

<div class="post-metadata">

**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\
**Post date:** [August 24, 2021, 11:05pm UTC](https://community.thunkable.com/t/api-request-unix-timestamp/1467381/2 "2021-08-24T23:05:26Z")

</div>

You could use the webviewer and vanilla JavaScript to convert this back into a human readable timestamp!

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [August 26, 2021, 9:10am UTC](https://community.thunkable.com/t/api-request-unix-timestamp/1467381/3 "2021-08-26T09:10:42Z")

</div>

Google sheet can do it easily

See my explanation in this post

> [@Open Weather Map Sunrise/Set Parsing](https://community.thunkable.com/t/open-weather-map-sunrise-set-parsing/1170832/12):
>
> This one is easy because Thunkable is using seconds since 1970 and what I do is connect a Google sheet as my data source and this sheet has two columns Unix-time and normal-time In the column normal time I have a formula =A2/86400+DATE(1970,1,1)+TIME(5,30,0) Then in Thunkable I update cell A2 and read cell B2 which has my answer. I use it to compute number of dates between two dates and other date functions.

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [August 26, 2021, 11:33am UTC](https://community.thunkable.com/t/api-request-unix-timestamp/1467381/4 "2021-08-26T11:33:16Z")

</div>

Another trick (for Android only)  
Add a `web viewer` to your screen and in the URL add this

```auto
data:text/html,<meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"/>
<h4>Unix To Standard Date</h4>
<div id="DisplayDate"></div>
<script>
	document.getElementById('DisplayDate').innerHTML = new Date(162984485300).toString();
</script>

```

You should see the human readable date of the Unix date number given.

Of course you can put this string in a variable and change the unix number as required.

---

<div class="post-metadata">

**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\
**Post date:** [November 8, 2024, 1:17pm UTC](https://community.thunkable.com/t/api-request-unix-timestamp/1467381/5 "2024-11-08T13:17:04Z")

</div>