function to_date
i have a field SDLSTRTDT with type VARCHAR2(8).The content of SDLSTRTDT is like this: 20071224
Now I would like to run the following select:
select * from tbtco where to_date(sdlstrtdt, 'YYYYMMDD') < '01-NOV-07' order by to_date(sdlstrtdt, 'YYYYMMDD');
ERROR at line 1:
ORA-01841: (full) year must be between -4713 and +9999, and not be 0
How can i use the to_date function correct. Thank you, Lutz