Search code examples
pythondatevariablestimestampdate-conversion

How to convert time stamp in Python from dd/mm/yy hh:mm:ss:msmsms to yyyy-mm-dd hh:mm:ss:msmsmsmsmsms

I have created an automated data client that pulls data from a txt file and inputs it into a csv file. Each data entry contains a timestamp, but it is not in the format I need it in, I need it to match the datetime.now() format:

ORIGINAL FORMAT [03/11/22 01:06:09:190]

DESIRED FORMAT 2022-11-03 01:06:09.190000

I am currently using the following code to pull the timestamp from each line of data I need: 82: reTimestamp = r'\d{2}/\d{2}/\d{2} \d{2}:\d{2}:\d{2}:\d{3}'

105:     for line in f:
106:         line.strip()
108:     timestamp = re.findall(reTimestamp, line.strip())

110: print(timestamp)

Output: ['03/11/22 01:05:06:172']

Every function is working well up until now because im having trouble converting this timestamp to the desired format. I would also like to get rid of the square brackets '[]'

Solution

  • Looks like timestamp is a list, to access the string try timestamp[0]

    And you can convert the string to your desired datetime format using the below code

    from datetime import datetime
timestamp = ['03/11/22 01:05:06:172']
datetime_object = datetime.strptime(timestamp[0], '%d/%m/%y %H:%M:%S:%f')
date_time = datetime_object.strftime("%Y-%m-%d %H:%M:%S.%f")
date_time
#Output: 2022-11-03 01:05:06.172000