Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
MySQL subtract 8 hours
DROP TABLE IF EXISTS datetimes; CREATE TABLE datetimes (id INT, datetime DATETIME); INSERT INTO datetimes (id, datetime) VALUES (1, '2018-05-08 19:06:15'); INSERT INTO datetimes (id, datetime) VALUES (2, '2018-05-08 02:12:23'); INSERT INTO datetimes (id, datetime) VALUES (3, '2018-05-08 23:00:03'); INSERT INTO datetimes (id, datetime) VALUES (4, '2018-05-08 20:33:56'); INSERT INTO datetimes (id, datetime) VALUES (5, '2018-05-08 18:19:31'); INSERT INTO datetimes (id, datetime) VALUES (6, '2018-05-08 16:43:47'); SELECT datetime FROM datetimes; UPDATE datetimes SET datetime = DATE_SUB(datetime, INTERVAL 8 HOUR) WHERE id > 1 AND id < 6; SELECT datetime FROM datetimes;
run
|
edit
|
history
|
help
0
MySQL : calculate overlapping periods
maa
ruthresh1
Charles Chung
Práctica MySQL 1
chandu
grre
1831
delivery_history
Conditional SQL select