Turn string record time into date format

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?



Hi @chumanhluan1005

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.