Convert SQL datetime to python datetime
--------------------------------------------
Solution:
- Import datetime
- set SQL datetime to a variable
- set SQL datetime format
- convert it to python date time using datetime
Step 1: Import datetime
import datetimeStep 2: Set SQL date to a variable -
sql_datetime = '2013-01-12 15:27:43'
formate = '%Y-%m-%d %H:%M:%S'Step 3: Convert the SQL datetime to python using datetime as bellow -
datetime.datetime.strptime(sql_datetime,formate)
datetime.datetime(2013, 1, 12, 15, 27, 43)