Answer / hrindows@gmail.com

NOW
NOW() give you the current date time in the format 'YYYY-MM_DD HH:MM: SS'
CURRENT
CURRENT_DATE() will only give you the current date in format "YYYY-MM_DD"

Answer / Ajay Raj Singh

In MySQL, CURRENT_DATE returns the current date (yyyy-mm-dd) and NOW() returns the current date and time (yyyy-mm-dd hh:mm:ss).

What is the difference between having and where clause in mysql? Explain

1 Answers  

---

What is a mysql server?

1 Answers  

---

How do I find mysql location?

1 Answers  

---

What are the advantages and disadvantages of using mysql?

1 Answers  

---

How to convert character strings to dates?

1 Answers  

---

How can we change the data type of a column of a table?

1 Answers  

---

What is dirty read and phantom read?

1 Answers  

---

What is a delimiter in mysql?

1 Answers  

---

Can we rollback truncate in mysql?

1 Answers  

---

What are features of mysql?

1 Answers  

---

What is max connection in mysql?

1 Answers  

---

What is the datatype for password in mysql?

1 Answers  

---