Updating a date back one day in Oracle SQL table

Updating a date back one day in Oracle SQL table

table

I am trying to update a date in a SQL table, I’d like to update the column create_time back one day in sql Then I want the final output should be:

CRETE_TIME
2021-12-14 16:52:31
2021-12-14 16:52:36
2021-12-03 16:52:40

All the create_time are back one day. Any ideas? I am a bloody beginner

Check Out These Simple Solutions To Starting A Business At Home Previous post Check Out These Simple Solutions To Starting A Business At Home
Next post Diving Deeper into Micro Economics Could Serve You Well – Book Review