Updating a date in Oracle SQL table
This is based on the assumption that you’re getting an error about the date format, such as an invalid month value or non-numeric character when numeric expected. Dates stored in the database do not have formats. When you query the date your client is formatting the date for display, as 4/16/2011. Normally the same date … Read more