I would like to know the easiest way to update a date field in pl/sql. I have a date field that was imported incorrectly from an .csv file into my oracle table.
The date field came in as follows:
08/24/0001 which should be 08/20/2001
09/01/0098 which should be 09/01/1998