23

I received the servertime from the Binance-API,I try to work with and it looks like this:

{ "serverTime": 1518440400000 }

The question is, how can I compute the date out of this stamp?

I tried

import datetime print(datetime.datetime.fromtimestamp( int("1518308894652")).strftime('%Y-%m-%d %H:%M:%S'))

But the date wasn´t valid.

Do you have ideas, or is it to specific? Thank you!

Improve this question
3
  • 1
    Is 1518440400000 is the actual timestamp you got back? If so, that would mean the server is running in the year 50087... But assuming that's just an example, most languages should have some function for this. What language are you using? Commented Feb 13, 2018 at 1:12
  • this is the same, what I got. I use python. Commented Feb 13, 2018 at 1:14
  • 2
    Question would have been so much more useful if you had posted the Binance API request. Commented Mar 13, 2021 at 2:56

3 Answers 3

Reset to default
40

You could use this:

from datetime import datetime datetime.fromtimestamp(int("1518308894652"))

But python says the year is out of range (understandably, considering it says it's 50087). So I suspect that serverTime is not a normal timestamp.

But assuming the response that you got was the timestamp, so you don't need to do any other conversions other than turning the string into an int.

Edit:

Turns out the docs say "All time and timestamp related fields are in milliseconds." So just divide the response by 1000 and you'll be fine: datetime.fromtimestamp(int("1518308894652")/1000). Source

Improve this answer
Sign up to request clarification or add additional context in comments.

4 Comments

I tried, but receive "ValueError: year 50083 is out of range" :/
@cosmonaut I edited the question with the fix. The Binance API docs gives the time is in milliseconds, whereas python expects a value in seconds.
@AidanGawronski I don't know if you're referring to the fact that accepted answer was switched, or my answer itself. I'm super sorry that that it was switched, I didn't mean for that to happen. I wrote a short answer while I researched the problem further, planning to edit my answer to give more info on the problem, and in that time you posted your answer. But I found all of this completely independently, I just googled "Binance API".
Fair enough. I believe you.
18

Your response is in milliseconds when datetime.fromtimestamp requires seconds.

import datetime print(datetime.datetime.fromtimestamp(1518308894652/1000)) # 2018-02-10 19:28:14.652000
Improve this answer

Comments

3

Pandas can handle this perfectly by specifying miliseconds as the unit.

import pandas as pd pd.to_datetime(1518440400000, unit='ms')

Timestamp('2018-02-12 13:00:00')

Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.