How to select with datetime where condition on Sap Cpq?

[sbslmhmt]

Hello,

I want to select from custom table based on a datetime field.

Here is my code:

import datetime
adate = datetime.datetime.now().replace(hour=0, minute=0, second=1)
a = SqlHelper.GetList("select Kur from KurTablosu WHERE KurTarihi = '"+adate+"'")<br>

Code throws below error:

unsupported operand type(s) for +: 'str' and 'datetime'

Anyone knows how to make it work?

[sbslmhmt · Accepted solution]

Found it if anyone needs it;

a = SqlHelper.GetList("select Kur, KurTarihi from KurTablosu WHERE KurTarihi = '"+adate.strftime("%m/%d/%Y %H:%M:%S")+"'")