I am trying to retrieve data from a database. The dates are stored as strings in the format of yyyy-mm-dd HH24:mm:ss.sss.
I want to allow the users to enter a date at a prompt then convert the entered value to that format.
I have tried To_Char(Userdate, 'yyyy-MM-dd HH24:MI:SS')
I get an error when I run a query. Database Error: ORA-01722:Invalid Number