Ekip OluşturunAPI'nizi EkleyinBelgeler
Oturum Aç
Kaydol

TikTok API

ÜCRETSİZ PREMIUM
Verified
✓
Taraf Omar M'Haimdat | Güncelleyen 15 days ago | Data
Popülerlik

9.8 / 10

Gecikme

4,356ms

Hizmet Düzeyi

100%

Health Check

100%

Tüm Tartışmalara Dön

Calculating the time/date

Rapid account: Juliaaaker
juliaaaker
a year ago

Hi! Thank you for making this API. I want to show in more user friendly ways the time and date of the video in a google sheet. How would I calculate/what formula would I use to show the date/time.

Thanks!

Rapid account: Omarmhaimdat
omarmhaimdat Commented a year ago

My pleasure, thank you for using TikTok API.

Rapid account: Juliaaaker
juliaaaker Commented a year ago

That worked!! Thank you!

Rapid account: Omarmhaimdat
omarmhaimdat Commented a year ago

Hello,

You can convert the unix timestamp to date by using this trick: (A5 / 86400) + DATE(1970, 1, 1). Replace A5 with your values.

Best,
OM

Aşağıya yorum ekleyerek tartışmaya katılın:

Yeni yorumlar göndermek için giriş yapın / kaydolun