What is the datatype of the column DATLIV?
If it's CHAR or VARCHAR2, the values returned by the following select are the troublemakers:
SELECT datliv FROM table@ggos
WHERE LENGTH(datliv) < 8;
However I have the strange feeling that the datatype of DATLIV is DATE. If this is tru then use TO_CHAR, not TO_DATE:
Select TO_CHAR(datliv,'yyyymmdd') from table@ggos;
Last edited by jmodic; 01-23-2003 at 09:50 AM.
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?