Add time zone option to inbuilt date/time functions

domonator
domonator Member
in Localization ideas

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.

Tagged:
2
Up
2 votes

Submitted and awaiting review from product team · Last Updated

Comments

  • brycec
    brycec Contributor

    You can achieve this via Beast Mode. So, they probably won't spend time adding it.

    CONVERT_TZ(NOW(), 'UTC', 'America/New_York')

    Was this comment helpful? Click Agree or Like below.
    Did this comment solve your problem? Accept it as the solution!

  • domonator
    domonator Member

    Hi @Brycec,

    I actually found that out too. However, when I asked Domo about this they said CONVERT_TZ isn't "supported" for use in Beast Modes or ETL (it's only for use in connector SQL or SQL data flows). So, although it works, it could stop working at any time and Domo wouldn't then be bound to provide any support (fix it).

    Thanks!

Categories