Error - "SQLite DateTime type only accepts Python " "datetime and date objects as input."

Question

I tried to declared a variable contains of Datetime like this

ts1.departure_date = '2012-03-03 10:10:10'

but then I got this error

StatementError: (exceptions.TypeError) SQLite DateTime type only accepts Python datetime and date objects as input. 

I wonder what is the correct way to declare a variable with datetime format? Thanks in advance

Answer 1

First import the datetime class:

from datetime import datetime

Then create a datetime object and use that to set your attribute:

ts1.departure_date = datetime(2012, 3, 3, 10, 10, 10)