Hi. I have a Bluehost mysql database and it works fine
CREATE TABLE Sensor (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
value1 VARCHAR(10),
value2 VARCHAR(10),
value3 VARCHAR(10),
reading_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)
Is there a way to make reading_time UTC or european time?
My problem is that I have to add + 8 hours to display the graph, but sometimes it has to be + 7 hours
Regards
Esben