Write a query to change the due_date ‘2018-01-01’ to ‘2018-01-09’ in the bill table

Write a query to change the due_date ‘2018-01-01’ to ‘2018-01-09’ in the bill table.

Solution

update bill set due_date = to_date('2018-01-09','YYYY-MM-DD') where due_date = to_date('2018-01-01','YYYY-MM-DD') 

Happy Learning – If you require any further information, feel free to contact me.