Hi,
Thanks for your answer.
As I've always pb with the syntax of pass-thru SQL ( the AS clause ...)
, and pb while using the oql.bind("02") ... I build the query by
concataning query + operator + parameter and then these following lines
are correctly running by oql.execute():
For mySql :
SELECT assure FROM fr.cnam.scapin.metier.donnees.assures.Assure assure
where month(assure.dateNaissance) like "%3"
SELECT assure FROM fr.cnam.scapin.metier.donnees.assures.Assure assure
where month(assure.dateNaissance) >= "10"
SELECT assure FROM fr.cnam.scapin.metier.donnees.assures.Assure assure
where month(assure.dateNaissance) = "02"
SELECT assure FROM fr.cnam.scapin.metier.donnees.assures.Assure assure
where month(assure.dateNaissance) != "10"
For Oracle :
SELECT assure FROM fr.cnam.scapin.metier.donnees.assures.Assure assure
where TO_CHAR(assure.dateNaissance,"MM")>= "10"
