MySQL Date Functions. This page shows you the most commonly used MySQL Date functions that allow you to manipulate date and time data effectively. Section 1. Getting the current Date & Time. This ...

CONVERT_TZ() converts a datetime value dt from the time zone given by from_tz to the time zone given by to_tz and returns the resulting value. Time zones are specified as described in Section 9.6, ...