Hi Malcolm,
Thanks for your update.
Using Expression column, we can’t able to convert UTC time to local time in Dashboard Designer. You can achieve your requirement using code view option if you are using server types connection like SQL, MySQL and Postgres.
For SQL server you can use DATEADD() function to add the hours or minutes in your date.
Example: If your local time is 2h ahead of Universal Coordinated Time, then you can add below line in your code view to achieve your requirement,
DATEADD(hour, 2, [date time column]) as [LocalTime]
If your local time is 5h 30m ahead of Universal Coordinated Time, then you can add below line in your code view to get the local time,
DATEADD(mi, 330, [date time column]) as [LocalTime]
Note: Here we have converted the 5 h 30 m to minutes (330) and then add the value with your date time column.
Please refer below screen shot for your reference,
For MySQL server, you can use DateAdd() function like as below,’
DATE_ADD([date column], INTERVAL 2 HOUR) as “LocalTime”
For Postgres server, you can use DateADD() function like as below,
[date column] + INTERVAL ‘2 hour’ as “LocalTime”
Please let us know if you need any further assistance.
Regards,
Renuka N.
