How to compare dates in PHP PROGRESS?

[nicolas]

I have a date = "2010/05/19"
my field "FechaBD" in Progres is datetime,

Basically I want to share: FechaBD <= Date

I am working with ODBC.
The SQL is: SELECT * FROM PUB.NombreTabla WHERE Cve1 = 10 AND (DATE(FechaBD) < DATE('2010/05/19') OR DATE(FechaBD) >= DATE('2010/05/19'))

Error: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about "DATE(Fecha) < DATE('2010/05/19') OR DATE" (10713)


Tks

 

[medu]

SELECT * FROM PUB.NombreTable WHERE Cve1 = 10 AND FetchaBD <= TO_DATE('month/day/year')