In python im getting error converting unix timestamp to date and time. Os Error #22

Asked Feb 18 '21 at 18:16

Active Feb 18 '21 at 18:16

Viewed 36 times

Guys Im taking this Unix timestamp and converting it to date time. I have tried absolutly everything and cant figure out why im getting this error. Can someone please help me figure this out please.

1605195918507251700

Using this function

def ts_to_datetime(ts) -> str:
    return datetime.datetime.fromtimestamp(ts / 1000.0).strftime('%Y-%m-%d %H:%M')

asked Feb 18 '21 at 18:16

lizardcoder

1

`1605195918507251700` is not a unix timestamp. Where did you get this value from? – gen_Eric Feb 18 '21 at 18:18
From the api im using it says the time stamp is a msec unix timestamp – lizardcoder Feb 18 '21 at 18:19
What API are you using? Does it offer another value that's a "proper" unix timestamp (in seconds)? – gen_Eric Feb 18 '21 at 18:21
polygon api and it does not how can I convert this time stamp which is msec unix timestamp to seconds unix timestamp – lizardcoder Feb 18 '21 at 18:22
I think the value you have is actually in μs, (microseconds) not ms (milliseconds). – gen_Eric Feb 18 '21 at 18:23
how could I convert it – lizardcoder Feb 18 '21 at 18:23
2

According to epochconverter.com it's a timestamp is in nanoseconds. So `datetime.datetime.fromtimestamp(ts / 1000000000).strftime('%Y-%m-%d %H:%M')` gives `'2020-11-12 10:45'` – 001 Feb 18 '21 at 18:24
I think you'd just need to divide it by `1000000` instead of `1000`. Try `ts // 1000000`. – gen_Eric Feb 18 '21 at 18:26
ok thank you I will try it – lizardcoder Feb 18 '21 at 18:27
@JohnnyMopp You're right. It's actually `1000000000` (not `1000000`) like I thought. I was a bit off in my amount of decimal places... – gen_Eric Feb 18 '21 at 18:27
It works guys thanks – lizardcoder Feb 18 '21 at 18:30

In python im getting error converting unix timestamp to date and time. Os Error #22

0 Answers0