Recently had an 1 z0-882, with a topic, do not remember the detail topic, review the usage of MySQL NOW,
Options are:

NOW ()
NOW (3)

I chose NOW () to get the current time. The home computer after the operation,

The SELECT NOW ();
The SELECT NOW (3);

Get the current time,
Do you have NOW (3) the usage? What is the difference between between the two?

Welcome!

CodePudding user response:

Parameter is milliseconds, write NOW () and NOW (0), said only the date and time, no milliseconds,
NOW (1) a millisecond, NOW two (2), NOW six (6), the range is 0 to 6;

CodePudding user response:

The SELECT NOW (). NOW (3);

NOW () NOW (3)
The 2018-05-02 10:29:49 2018-05-02 10:29:49

There is no milliseconds

CodePudding user response:

refer to the second floor furnaceforgold response:

SELECT NOW (.) NOW (3);

NOW () NOW (3)
The 2018-05-02 10:29:49 2018-05-02 10:29:49

No ms

Your client display format, is actually a millisecond,

PS: the official document is the instructions, recommended reading,

CodePudding user response:

Would like to ask the building Lord, under the 882 exam question bank you cover the ratio of how many, heard that is better to take an examination of 883?