Convert timestamp to mysql friendly format in python

Question

I got "timestamp": "2018-10-28T12:49:00.816Z" from a API response. How can I convert 2018-10-28T12:49:00.816Z to %Y-%m-%d %H:%M:%S format.I tried datetime.strptime

Christian Sloper · Accepted Answer · 2018-10-28 15:30:48Z

4

This is suprisingly easy using dateutil

import dateutil

dateutil.parser.parse("2018-10-28T12:49:00.816Z")

output:

datetime.datetime(2018, 10, 28, 12, 49, 0, 816000, tzinfo=tzlocal())

or directly to your format:

dateutil.parser.parse("2018-10-28T12:49:00.816Z").strftime('%Y-%m-%d %H:%M:%S')

output:

 '2018-10-28 12:49:00'

answered Oct 28, 2018 at 15:30

Christian Sloper

7,5303 gold badges17 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert timestamp to mysql friendly format in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related