How to convert datetime string back to datetime object?

Question

I save the datetime string in the database. Now I am facing a problem. When I take a row from the database, I need to convert it back to a datetime object ...

Any easy way to do this?

The date and time string looks like this:

 2010-11-13 10:33:54.227806 

Answer 1

You want datetime.strptime (date_string, format).

 from datetime import datetime datetime.strptime("2010-11-13 10:33:54.227806", "%Y-%m-%d %H:%M:%S.%f") 

For more information on the format string, see http://docs.python.org/library/datetime.html#strftime-and-strptime-behavior

Answer 2

I suggest you install python-dateutilt :

 from dateutil import parser d = parser.parse(yourstring) 

This library gets the datetime object from your date string in a smart way ...

Answer 3

 # time tuple to datetime object time_tuple = (2008, 11, 12, 13, 51, 18, 2, 317, 0) dt_obj = datetime(*time_tuple[0:6]) print repr(dt_obj) # date string to datetime object date_str = "2008-11-10 17:53:59" dt_obj = datetime.strptime(date_str, "%Y-%m-%d %H:%M:%S") print repr(dt_obj) # timestamp to datetime object in local time timestamp = 1226527167.595983 dt_obj = datetime.fromtimestamp(timestamp) print repr(dt_obj)