You should use a datetime object, not str .
>>> from datetime import datetime >>> cr_date = datetime(2013, 10, 31, 18, 23, 29, 227) >>> cr_date.strftime('%m/%d/%Y') '10/31/2013'
To get a datetime object from a string, use datetime.datetime.strptime :
>>> datetime.strptime(cr_date, '%Y-%m-%d %H:%M:%S.%f') datetime.datetime(2013, 10, 31, 18, 23, 29, 227) >>> datetime.strptime(cr_date, '%Y-%m-%d %H:%M:%S.%f').strftime('%m/%d/%Y') '10/31/2013'
source share