localtime

Applies the localtime modifier to a date/time value, converting it from UTC to the local time zone.

This is particularly useful when used with now(), which returns the current UTC time. Applying localtime() will adjust this time to reflect the system's current local time zone. If the original time value is already in local time, this modifier has no effect.

Example

// Get the current local date and time
select(DATETIME().now().localtime()).execute()

See also