# 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:** 1
**Showing post:** 3

<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.

---

_[View the full topic](https://community.thunkable.com/t/api-request-unix-timestamp/1467381)._