80

MySQL CURRENT_DATE() Function

The current_date() is a MySQL date/time function. It is used to get the current date.

Syntax

Parameters

NA

Returns

The current_date() function returns the current date. It will return the current date as a ‘YYYY-MM-DD’ format if used in a string context. It will return the current date as a YYYYMMDD format if used in a numeric context.

Example 1

Output:

Example 2

Output: