Run Code
|
API
|
Code Wall
|
Users
|
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
Please
log in
to post a comment.
emp
Datensätze, die sich zeitlich 4 mal überlappen
Cuba
Comparación de Collations general-spanish-latin en MySQL
Aula1
Estudiantes
index
ruthresh
Point System Alpha
My mysql code - sunil
Please log in to post a comment.