Curdate() Vs current_date MySql

mysql sql-date-functions
Bharanidharan picture Bharanidharan · Jan 6, 2014 · Viewed 7k times · Source

What is the difference between curdate() and current_date in MySQL?

Answer

Barmar picture Barmar · Jan 6, 2014

There's no difference. It says it right there in the manual:

CURRENT_DATE and CURRENT_DATE() are synonyms for CURDATE().

Related questions

Mysql DATE_SUB(NOW(), INTERVAL 1 DAY) 24 hours or weekday?

I am trying to get the total amount of registered users per day. At the moment I am using this: $sql = "SELECT name, email FROM users WHERE DATE_SUB(NOW(), INTERVAL 1 DAY) < lastModified" But I am not sure if …

Read More
How can I use SQL's YEAR(), MONTH() and DAY() in Doctrine2?

I want to perform a query which would look like this in native SQL: SELECT AVG(t.column) AS average_value FROM table t WHERE YEAR(t.timestamp) = 2013 AND MONTH(t.timestamp) = 09 AND DAY(t.timestamp) = 16 AND t.somethingelse LIKE …

Read More
Need to subtract some hours from given timestamp in hive

Input: unix_timestamp('01/15/2018 15:26:37', 'mm/dd/YYYY hh:mm:ss') Expected output is 4 hours delay from above utc input time i.e 01/15/2018 11:26:37 I know that there is date_sub function in hive but it is only used to subtract …

Read More