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