Curdate() Vs current_date MySql

Question

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

try to search for the answer yourself first....its very simple question — AbdulRahman Ansari, Jan 06 '14 at 06:48
@AbdulRahmanAnsari has it occurred to you that StackOverflow is a knowledgebase? Do you think this website should be reserved exclusively for the most complicated questions? — reformed, Jan 04 '22 at 21:37

score 26 · Answer 1 · answered Jan 06 '14 at 06:48

26

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

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

answered Jan 06 '14 at 06:48

Barmar

score 4 · Answer 2 · edited May 23 '17 at 12:17

4

curdate() and current_date() are synonymous.

However for your information there is a difference between curdate() and now()

edited May 23 '17 at 12:17

Community

answered Jan 06 '14 at 06:52

cosmicchichu

score 1 · Answer 3 · answered Jan 06 '14 at 06:48

1

There is no difference, they are synonyms (see here).

answered Jan 06 '14 at 06:48

Mureinik

3 Answers3