I am looking for a way to get the current time in a time zone, for purposes of checking a certain time has passed in that time zone. e.g. An event has already started or ended on this day in a certain timezone.
"today('Pacific/Auckland')" provides the current day at 12:00AM and not the current time.
"to_local_time" and "local_dt" are base on the timezone setting of your portal, not a specified time zone.