Skip to Content
0
Jun 20, 2020 at 11:29 AM

convert_tz function is not working in information design tool when creating a derived table

81 Views

I am using Information design tool to create a universe. The underlying database is a Maria DB where the date and date time fields are stored in UTC format. However in the Webi we need to show the output in EST format. Hence I am trying to use the convert_tz function to create a derived table to change UTC to EST format in the universe itself. However IDT shows convert_tz is not a recognized function. Please advise how I can have my use case accomplished.