ValueError: time data '(datetime.datetime(2018, 8, 21, 14, 14, 18, 233000),)' does not match format '%Y-%m-%d'

I'm trying to program a script that pulls data from SQL and push it into Quickbase. I only need Year, Month, and Day from my rows

here's the output from print result

(datetime.datetime(2018, 11, 30, 19, 52, 32, 927000),)
(None,)
(datetime.datetime(2018, 10, 17, 21, 39, 37, 163000),)
(datetime.datetime(2016, 12, 30, 20, 14, 23, 133000),)
(datetime.datetime(2018, 10, 17, 21, 31, 21, 853000),)
(datetime.datetime(2017, 2, 27, 21, 26, 51, 307000),)
(datetime.datetime(2018, 12, 20, 20, 35, 29, 997000),)
(datetime.datetime(2019, 9, 5, 15, 29, 22, 967000),)
(datetime.datetime(2018, 8, 13, 21, 57, 3, 307000),)
(datetime.datetime(2018, 10, 17, 21, 28, 23, 60000),)

Here is what I have

for result in cursor.fetchall():
    print(result)
    result = datetime.strptime(str(result), '%Y-%m-%d')



    #client.edit_record(rid = result , fields = {'99' : '1' }, database=CONTACTS_TABLE)
cursor.commit()
cursor.close()

heres my error

ValueError: time data '(datetime.datetime(2018, 8, 21, 14, 14, 18, 233000),)' does not match format '%Y-%m-%d'

Any input appreciated!

Solution

I think that you have the problem that you are trying to convert a tuple to str, that is not the problem but that don't help you.

I recommend do something like this if you want to save a str:

for result in cursor.fetchall():
    print(result)
    result = '%d-%d-%d' % (result[0].year, result[0].month, result[0].day)

or if you want to save a date object, just create a new datetime.date with that values