2 Replies Latest reply on Jun 25, 2018 4:00 PM by elias.daniels.0

    Custom SQL Convert_Tz Error / Time Zone conversion

    elias.daniels.0

      Hi guys,

       

      I'm trying to run a SQL that already worked in MySql, on Tableau. Its giving me the following error:

       

       

      The original SQL is : convert_tz(`when`, "UTC", "Australia/Melbourne")

       

      Is there a calculation to convert the time zone within tableau considering daylight saving.

       

      Or perhaps modifying something in the sql query?

       

      Cheers,

       

      Elias