Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question