I'm trying to execute the query
|| completed_time,'YYYYMMDDHH24:MI') from change_order
and I'm getting the error :
Ora 1840 Input value not long enough for date format.
I'm executing in a database in which full database import was done from another database.Now,this query was working in the original database.
Is there any parameter setting that I should give for this query to work?.