when i execute this sql query,

{ sql2 = 'INSERT INTO gest_caisse (mt_depense, appro_id, name) VALUES ('+str(total)+', '+str(r.id)+', '+str(r.odate)+')'

(and r.odate is a date like 2019-05-14 ...) }

i got this error {

psycopg2.ProgrammingError: ERREUR:  la colonne « name » est de type date mais l'expression est de type integer
LINE 1: ...isse (mt_depense, appro_id, name) VALUES (0.0, 8, 2019-05-23...

HINT: You must rewrite the expression or apply a type transformation to it.

}

so how can i transfor my r.odate to execute my query correctly.