MySQL LOCALTIME() Function

 The LOCALTIME() function in MySQL returns the current date and time in the session's time zone, formatted as YYYY-MM-DD HH:MM:SS. It is equivalent to the NOW() function without the fractional seconds, and it doesn't require any arguments.

Syntax:

LOCALTIME()

Example Usage:

SELECT LOCALTIME();

This will return the current local date and time in the format YYYY-MM-DD HH:MM:SS.

Notes:

• The time returned by LOCALTIME() is based on the time zone set for the MySQL session. You can check or set the time zone using the time_zone system variable.
• If you need to return the current date and time in UTC, you can use UTC_TIMESTAMP() instead.