Add time zone option to inbuilt date/time functions

The Domo functions such as NOW(), CURRENT_TIME(), CURRENT_TIMESTAMP(), CURTIME() all return times in UTC. It would be great if these could all be modified to take additional optional parameter of time zone so that the return values are shifted to the local time appropriate to the given time zone (including daylight savings if/when applicable). For example:-

NOW( 'America/New_York') would return UTC -5/-4 hours depending on whether daylight savings are in effect or not.

1
1 votes