Covert datetime64[ns, UTC] to datetime64 python

Question

I have a column with datetime UTC date

2020-01-01 00:00:00+00:00

Can someone help me to convert it to just datetime64 for eg:

2020-01-01

Could you share some more details, e.g. how do you read this column in your python code? Is that a string or some builtin db date type? what is your database system? — Pac0, May 29 '20 at 09:33
if you use pandas (this seems to be the case) you can change it like that: df.dates.apply(lambda x: x.date()) — S.A, May 29 '20 at 09:34

score 1 · Accepted Answer · answered May 29 '20 at 09:39

1

if you use pandas (this seems to be the case) you can change it like that:

df.dates.apply(lambda x: x.date()) # where dates is your datetime column

answered May 29 '20 at 09:39

S.A

score 0 · Answer 2 · answered May 29 '20 at 09:34

0

Try the datetime package with Python 3.2+.

import datetime
a='2020-01-01 00:00:00+00:00'
print (datetime.datetime.strptime(a,'%Y-%m-%d %H:%M:%S%z').strftime('%Y-%m-%d'))

answered May 29 '20 at 09:34

Prateek Dewan

1

you can use `datetime.datetime.fromisoformat()` here - it is [much more efficient](https://stackoverflow.com/a/61710371/10197418) ;-) – FObersteiner May 29 '20 at 09:38
1

Ah. Python 3.7+! My Python is clearly out of date :) Thanks! – Prateek Dewan May 29 '20 at 09:42
sure, I always forget the "python3.7+" tag... sorry ;-) – FObersteiner May 29 '20 at 09:44

2 Answers2