I know there are loads of postings regarding fixing this error but, I'm just not understanding it!
val_strg1 value is
01.04.2016. I want to use this and not show lines where this date is older than current date, (i.e.
and trunc(sysdate) < dv.val_strg1).
But, even though I have used a to_date format, I still get the
a non-numeric character was found where a numeric was expected error?
I have tried several to_date formats;
The following gives me a
'not a valid month' error?
select val_strg, val_strg1, to_date(val_strg1,'DDMMYYYY')
where name = 'HYPERCARE_CUNR'
order by sort_no
How can I use the
val_strg1 as a date?