Converting string into datetime

Question

I want to covert a large complex date-time string into proper datetime fields in a database,  Can someone tell me a short method to do it, I am attaching a simple example for ref.

    Jun 24 2019  8:04PM
    Sep 28 1999 10:00AM

I can't use SQL.

Answer 1

It's a very easy task to do, just follow this syntax to get your result:

from datetime import datetime

datetime_object = datetime.strptime('Jun 4 2019  3:25PM', '%b %d %Y %I:%M%p')

String used above i.e. datetime.strptime can handle all kinds of Formats. 

Hope this helps.

Answer 2

You can use the third party dateutil library:

from dateutil import parser

dt = parser.parse("Aug 28 1999 12:00AM")

You can use the following video tutorials to clear all your doubts:-