Try SELECT ...TRUNC(term_dt)... See if that fixes it. If it does, there is
probably a problem with the time portion of the date field. In Oracle, a
DATE datatype includes TIME.
"James Williams" <JKWMSGA_at_YAHOO.COM> wrote in message
news:ajbjms$m99$1_at_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 - 15:05:44 CDT
