Filtering dates using TO_DATE(). Is there an alternative.

Is there an alternate method (through ODBC) for filtering rows based on dates other than the TO_DATE() function? Other data sources allow you to use the '#' character to delimit dates. For example, is there an alternative tothe following?

SELECT custid FROM XCB.TABLE WHERE DATE > TO_DATE('31-DEC-1997','DD-MON-YYYY') TIA,         Bruce Received on Thu Jul 02 1998 - 17:19:41 CDT