How do you make Apscheduler run at specific time from sql database

[IfeOduyemi]

does anyone know how to turn sql DATETIME type into python datetime type because I want APScheduler to run at a specific time. ``` conn = sqlite3.connect('finance.db')
cursor = conn.cursor()
time_event = cursor.execute("SELECT events_time FROM events WHERE id = 28")
user_time = (" ".join(time_event))
sql_datetime_obj = datetime.datetime.strptime(user_time, "%Y-%m-%d %H:%M:%S")
conn.close()
scheduler = BackgroundScheduler(daemon=True)
scheduler.add_job(send_mail, 'date', run_date=sql_datetime_obj)
scheduler.start()

[agronholm]

What's the problem with that code (other than it exits right after starting the background scheduler)?

[IfeOduyemi]

so sql_datetime_obj = strptime(user_time, "%Y-%m-%d %H:%M:%S")
it now says strptime is not defined do i have to import it?

[agronholm]

Now you dropped the entire datetime.datetime, when I told you to only strip the .datetime part.

[IfeOduyemi]

sorry yes i did that but it said that 'time data '' does not match format '%Y-%m-%d %H:%M:%S'

[agronholm]

Then it looks like the input data is not a timestamp at all. Check your input.

[IfeOduyemi]

yes thank you sorry my input was a text