• Skip to main content
  • Skip to primary sidebar

RNTLab.com

The Ultimate Shortcut to Learn Electronics and Programming with Open Source Hardware and Software

  • Courses
  • Forum
    • Forum
    • Ask Question
  • Shop
  • Account
  • Blog
  • Login

reading_time

Q&A Forum › Category: ESP32 › reading_time
0 Vote Up Vote Down
Esben Andersen asked 11 months ago

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

Primary Sidebar

Login to Ask or Answer Questions

This Forum is private and it’s only available for members enrolled in our Courses.

Login »

Latest Course Updates

  • [eBook Released] Build Web Servers with ESP32 and ESP8266 (version 1.0) October 27, 2020
  • [eBook Updated] Download Build ESP32-CAM Projects using Arduino IDE (version 1.1) August 31, 2020

You must be logged in to view this content.

Contact Support - Refunds - Privacy - Terms - MakerAdvisor.com - Member Login

Copyright © 2013-2021 · RandomNerdTutorials.com · All Rights Reserved