Why cannot the now () function display time?

{Code. However, after submission, only the date is available in the phpmyadmin database, and there is no time. the output is also like this -- {code ...} but executing selectnow () directly in it can get the current date and accurate time. Why can't I do it when I submit it?

$ Query = "insert into class (name, time) VALUES ('$ name', NOW ())";

Such a sentence. However, after submission, only the date is available in the phpmyadmin database, and there is no time. the output is also like this --

Tian2016-11-24tian2016-11-23tian2016-11-24tian2016-11-24tian2016-11-24

However, if you execute select now () directly in it, you can get the current date and accurate time. Why can't you do it when you submit it?

Reply content:

$ Query = "insert into class (name, time) VALUES ('$ name', NOW ())";

Such a sentence. However, after submission, only the date is available in the phpmyadmin database, and there is no time. the output is also like this --

Tian2016-11-24tian2016-11-23tian2016-11-24tian2016-11-24tian2016-11-24

However, if you execute select now () directly in it, you can get the current date and accurate time. Why can't you do it when you submit it?

Check whether the time field in your table is set to Datetime. if it is set to Date or char (10), it will be truncated due to incorrect format or length.