Invalid Datetime Format on SELECT statement

From: James Williams <JKWMSGA_at_YAHOO.COM>
Date: Tue, 13 Aug 2002 14:37:54 -0700
Message-ID: <ajbjms$m99$1@slb4.atl.mindspring.net>

We recently migrated one of our databases from Gupta's SQLBase to Oracle 8i. I had a bunch of VB programs that use RDO to access the database. While most of these work fine with Oracle, one doesn't. The one that fails has the following select statement.

SELECT EMPL_ID, LAST_NAME, HIRE_DT, TERM_DT FROM EMPL; This statement runs fine in SQLPlus. But if execute this select statement with RDO, I get Invalid Date Format. With a little debugging, I found out that the column giving me problems in TERM_DT. HIRE_DT doesn't have any problems. Both TERM_DT & HIRE_DT are defined as DATE. The only difference is that HIRE_DT won't allow nulls. I've eyeballed all of the term dates and they all look fine. I've aslo changed TERM_DT to NVL(TERM_DT,''), but I still get the error.

Any suggestions would be appreciated.

Thanks
James Williams
JKWMSGA_at_YAHOO.COM Received on Tue Aug 13 2002 - 16:37:54 CDT