MySQL MariaDB inserting wrong time in column of data type datetime

Question

This is my table:

CREATE TABLE tblWidget (
    id int,
    title varchar(255),
    name varchar(255),
    dateAdded datetime NOT NULL DEFAULT NOW());

and this is my insert query:

INSERT INTO tblWidget (id, title, name)
    VALUES (602, 'title', 'name');

and the values after executing the select statement are:

id   title   name   dateAdded
607  title   name   2016-03-10 23:04:20

Everything is ok except time. At the time of insertion the time of my computer was 3:15 and inserted time was different.

You might be interested stackoverflow.com/questions/930900/… — Mihai
– Mihai, Commented Mar 10, 2016 at 10:26
Which version are you running? What timezones are in effect on the two machines? — Rick James
– Rick James, Commented Mar 11, 2016 at 4:34

Zamrony P. Juhara · Accepted Answer · 2016-03-10 10:22:18Z

2

NOW() gets datetime from machine where MySQL server runs.

answered Mar 10, 2016 at 10:22

Zamrony P. Juhara

5,2822 gold badges26 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1