I have a date that is a varchar2 and I would like to make it a date field. I created a second field named datefield and want to insert into datefield as select from varchar2field. Do I need a specific format or is to_date all I need. I am trying to avoid any Oracle errors when I try to create a view to select the datefield, such as not a valid month, or ORA-01858: a non-numeric character was found where a numeric was expected.
Additionally, does anyone know of a great reference to learning about Oracle date and learning to love Oracle date, I am interested in learning, living, and never again having problem with Oracle date, no more Ora errors. Thank you for your help.