my sql date code example
Example: 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());