0 votes
in General by (35.7k points)
closed by

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?

1 Answer

+1 vote
by (36.0k points)
selected by
Best answer

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 YYYY-MM-DD HH:MM:SS. uuuuuu format, depending on whether the function is used in a string or numeric context.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.