i have a data in my table where my datefield is a varchar 8.
date is stored as 19750112
i am trying to convert a into a date and daysbetween
like select days_betweem(dob,now()) as age from table1.
this is the error i am getting.
: invalid DATE, TIME or TIMESTAMP value: Error while parsing DATE/TIME at function to_date()
can someone help me out please.