The Question : Reena is working with functions of MySQL. Explain her following:i. What is the purpose of now () function?ii. How many parameters does it accept?iii. What is the general format of its return type?
Solution for the question :
i. It returns the current date and time.
ii. None
iii. The return type for NOW() function is either in ‘YYYYMM-DD HH:MM:SS’ format or YYYYMMDDHHMMSS.uuuuuu format, depending on whether the function is used in a string or numeric context.
The correct answer to the question is researched by our moderators and shared with you. You can give feedback by commenting for the answers you think are wrong.