Re: Error when accessing a DB-view via MS-Access / ODBC

From: Justin Cave <jocave_at_yahoo.com>
Date: 20 Jun 2003 14:01:47 -0700
Message-ID: <233b7a65.0306201301.72e2ed2f@posting.google.com>

kielhd_at_freenet.de (kielhd) wrote in message news:<10a4173d.0306052232.3908bf72_at_posting.google.com>...
> To have the date displayed in a different format, I changed line 6 to
>
> 6 to_char(to_date(COMPUTER.OS_INST_DATE, 'DY MON DD
> HH24:MI:SS YYYY'), 'DD.MM.YYYY') OS_INST_DATE,
>
> and the following error occured:
>
> ODBC Call failed
> [Oracle][ODBC][Ora]ORA-01846: not a valid day of the week (#1846).

Are you able to query this view from SQL*Plus without the error?

Is COMPUTER.OS_INST_DATE a varchar2 column? If so, why are you storing date information in a character column? It's going to be much more pleasant to store the data in a date column.

Justin Cave Received on Fri Jun 20 2003 - 16:01:47 CDT