LOCALTIME

Returns the local time. If no time is specified, the current time is used. If no timezone offset is specified, the offset of current zone is used.

Syntax

LOCALTIME({UTC-time},{timezone-offset})

Arguments

UTC-time Time in UTC format. If omitted, uses the NOW() function to retrieve the localtime. Use the format (hour, minute, seconds)

timezone-offset Number of time zones to adjust the time.

Example

LOCALTIME((8,23,15),4) returns 12:23:15.

UTC-time	Time in UTC format. If omitted, uses the NOW() function to retrieve the localtime. Use the format (hour, minute, seconds)
timezone-offset	Number of time zones to adjust the time.