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

    Custom SQL Convert_Tz Error / Time Zone conversion


      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?