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

CodePudding user response：

You can try this:

update table_name
set CREATE_TIME = CREATE_TIME - 1;

CodePudding user response：

Update table_name set create_time = create_time -1