I am confusing with datetime64 and trying convert to normal time format, hope to get any suggestion from you guys :
I have a column with timestamp format : 2022.01.02D23:10:12.197164900
Output expected is : 2022-01-02 23:10:12
I’m trying with :
df['executionTime'] = pd.to_datetime(df['executionTime'], format='%Y-%m-%d %H:%M:%S.%f', errors='coerce')
Thank you so much!
>Solution :
Try this:
df['executionTime'] = pd.to_datetime(df['executionTime'], format='%Y.%m.%dD%H:%M:%S.%f', errors='coerce')