- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- 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)
Updated on 28-Jan-2020 10:57:02
- Related Questions & Answers
- What is the difference between MySQL NOW() and SYSDATE()?
- CURDATE () vs NOW() in MySQL
- What is the difference between MySQL LENGTH() and CHAR_LENGTH() function?
- What is the difference between MySQL stored procedure and function?
- What is the difference between MySQL ISNULL() function and IS NULL operator?
- What is the significant difference between MySQL TRUNCATE() and ROUND() function?
- 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 SQL and MySQL?
- What is the difference between a method and a function?
- What is the difference between CHAR and NCHAR in MySQL?
- What is the difference between CHAR and VARCHAR in MySQL?
- What is the difference between MySQL INSTR() and FIND_IN_SET() functions?
- What is the difference between UNIX TIMESTAMPS and MySQL TIMESTAMPS?
- What is the difference between MySQL LOCATE() and FIND_IN_SET() functions?
Advertisements