What is the different between NOW() and CURRENT_DATE()?



What is the different between NOW() and CURRENT_DATE()?..

Answer / shiwanshu

Now() Show the current date with time with AM/PM
Current_date () show only the current_date

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How to install mysql?

0 Answers  


If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?

0 Answers  


Is primary key auto increment?

0 Answers  


What is definer in mysql trigger?

0 Answers  


What is the use of mysqli_num_rows?

0 Answers  






How to Change a users password from unix shell.

0 Answers  


What is a mysql view?

0 Answers  


How to concatenate two character strings?

0 Answers  


How do I create a stored procedure in mysql?

0 Answers  


How do I find the database name in mysql?

0 Answers  


Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

0 Answers  


how we can use more then one primary key in Single Table

9 Answers   Systematix,


Categories