M
M
Melasti2019-01-03 03:16:35
SQL
Melasti, 2019-01-03 03:16:35

How to add time using SQL query?

There is a time column with the value 2019-01-03 02:55:00+03:00
I want to conditionally add 8 hours, I do it through the UPDATE table SET time = DATETIME(time, '+8 hours') where id = 1 query, but as a result I get 2019-01-03 07:55:00 , +0300 disappears.
Tell me how to make a request so that the time zone remains?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question