mysql surdate code example

Example 1: mysql current date

In MySQL the CURDATE() returns the current date in 'YYYY-MM-DD' format or 'YYYYMMDD' format depending on whether numeric or string is used in the function. CURRENT_DATE and CURRENT_DATE() are the synonym of CURDATE()

Example 2: get individual date elements in mysql

-- To get the year of a date in mysql
SELECT YEAR(NOW());

-- To get the month of a date in mysql
SELECT MONTH(NOW());

-- To get the day of a date in mysql
SELECT DAY(NOW());

-- To get the hour of a date in mysql
SELECT HOUR(NOW());

-- To get the minute of a date in mysql
SELECT MINUTE(NOW());

-- To get the second of a date in mysql
SELECT SECOND(NOW());