Hi all,
In my data, I have the record time format as 2019-06-15T23:47:09.736000+0000 currently in string format. Could you please consult on how to convert it into date format?
Thanks,
Luan
Hi all,
In my data, I have the record time format as 2019-06-15T23:47:09.736000+0000 currently in string format. Could you please consult on how to convert it into date format?
Thanks,
Luan
Converting from that string to date depends on the environment that you are at. For example, if you are in Python, converting that to a “Date” instance can be done using the following code:
from datetime import datetime
datetime.strptime('2019-06-15T23:47:09.736000+0000', '%Y-%m-%dT%H:%M:%S.%f%z')
If Excel however you need to enter the format, though I’m not familiar with that.
Hope it helps
Thanks, I will do that in Python.