mysql where in function of date code example

Example 1: convert_tz mysql

CONVERT_TZ(datetime, from_tz, to_tz)

Example: 
SELECT CONVERT_TZ('2031-09-21 02:42:14', 'UTC', 'America/New_York');
output: 2031-09-20 22:42:14

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());