- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What is the difference between MySQL NOW() and CURDATE() function?
As the name suggests CURDATE() function will return the current date. In simple words, we can say that it would return only the date not time.
mysql> select CURDATE(); +------------+ | CURDATE() | +------------+ | 2017-10-28 | +------------+ 1 row in set (0.00 sec)
In contrast, NOW() function will return current date and time.
mysql> Select NOW(); +---------------------+ | NOW() | +---------------------+ | 2017-10-28 09:10:16 | +---------------------+ 1 row in set (0.00 sec)
- Related Articles
- CURDATE () vs NOW() in MySQL
- What is the difference between MySQL NOW() and SYSDATE()?
- How can I use INTERVAL keyword with MySQL NOW() and CURDATE() functions?
- How to make MySQL's NOW() and CURDATE() functions use UTC?
- What is the difference between MySQL LENGTH() and CHAR_LENGTH() function?
- What is the difference between MySQL stored procedure and function?
- What is the significant difference between MySQL TRUNCATE() and ROUND() function?
- What is the difference between MySQL ISNULL() function and IS NULL operator?
- What is the difference between SQL and MySQL?
- What is the difference between a method and a function?
- What is the difference between: var functionName = function() {} and function functionName() {} in Javascript
- What is the difference between order and rank function in R?
- What is the difference between class and typeof function in R?
- What is the difference between MySQL TRUNCATE and DELETE command?
- What is the difference between UNIX TIMESTAMPS and MySQL TIMESTAMPS?

Advertisements