JDBC/ODBC Query - String date format ?

LRN

New Member
I'm new with progress database and I need to make a query to some progress tables by jdbc/odbc, but I'm having some problems with the date format in my query string.

What is the date format to use in my method:

statement.executeQuery("select column from table where columnDate > ??????");

I tried using YYYY/MM/DD, YYYY-MM-DD, and lots of other formats.

Thanks!!!
Leonardo
 
Top