CODEWITHSUNDEEP
mysqlphpmyadmin
blueSky
blueSky

Reputation: 247

phpMyAdmin -how to manually change datetime value

phpMyAdmin - I need to manually change datetime value in a column.

current value - 2018-11-03 20:47:18

desired value - 2018-11-02 20:41:50

After editing the cell and pressing Enter the result is:

2018-11-02 20:41:50.000000

I tried multiple times - seems there is no way - the nulls are always added.

The column is datetime type, without default values.

Any help?

Upvotes: 0

Views: 619

Answers (1)

MPK1
MPK1

Reputation: 346

The zeros at the end are added automatically and make no difference. PHP for example inserts DATETIME without them, but the phpmyadmin editor does. They wont affect the value itself.

If you don't wat to see the zeros, execute the following query:

UPDATE table SET column = "2018-08-20 00:00:00" WHERE id = 999

Upvotes: 3

Related Questions