how to convert datetime to numeric format in Python

Question

I have following datetime in Python and want to convert it to numeric

 2020-04-01  12:30:01

When I convert this to number in excel it returns 43922.5208449074. How to get the same number in Python?

I tried with following

datetime.fromisoformat('2020-04-01 12:30:01').timestamp()

But it does not return me the same number. How can we do it in Python

This question asked many times in stackoverflow. Didn't you try that all? — Kalana
– Kalana, Commented Apr 30, 2020 at 6:43
That is the "OLE automation date format". Mention that. So people would not get confused and you will get proper answer. — Dishin Goyani
– Dishin Goyani, Commented Apr 30, 2020 at 7:04

Jani Ahmad · Accepted Answer · 2020-04-30 06:51:06Z

1

If i am understanding your problem, you can use it

# Importing datetime.
from datetime import datetime
# Creating a datetime object so we can test.
a = datetime.now()

# Converting a to string in the desired format (YYYYMMDD) using strftime
# and then to int.
a = int(a.strftime('%Y%m%d'))
print (a)

answered Apr 30, 2020 at 6:51

Jani Ahmad

111 bronze badge

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

Collectives™ on Stack Overflow

how to convert datetime to numeric format in Python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related