팀 만들기API 추가문서
로그인
가입하기

TikTok API

부분 유료
분류별 Omar M'Haimdat | 업데이트됨 לפני 23 ימים | Data
인기

9.8 / 10

지연 시간

4,137ms

서비스 수준

100%

Health Check

100%

모든 토론으로 돌아가기

Calculating the time/date

Rapid account: Juliaaaker
juliaaaker
לפני שנה

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 לפני שנה

My pleasure, thank you for using TikTok API.

Rapid account: Juliaaaker
juliaaaker Commented לפני שנה

That worked!! Thank you!

Rapid account: Omarmhaimdat
omarmhaimdat Commented לפני שנה

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

아래에 의견을 추가하고 토론에 참여하세요.

새 댓글을 게시하려면 로그인 / 가입