adding 1 day to a date of format YYYYMMDD format and it is char.
828690Apr 11 2011 — edited Apr 11 2011HI,
I have a column checktodate which is declared as char(8) and it is of format YYYYMMDD.
some of the values in the checktodate column are null and blank also.
I have to give a condition as
checktodate+1>= sysdate.
I am giving as
TO_CHAR(to_date(nvl(CHECKTODATE,0),'yyyymmdd')+1,'yyyymmdd') >= TO_CHAR(SYSDATE ,'YYYYMMDD')
I am getting the error as
ORA-01840: input value not long enough for date format
01840. 00000 - "input value not long enough for date format"
*Cause:
*Action:
kindly suggest.
Thank you.
Regards
Chaitanya.