Function NOW() Output Does Not Match System Time When Set as UTC+8 Ulaanbaatar

Issue

When using Function NOW(), the output does not match system time, when the system is using UTC-8-Ulaanbaatar as Time Zone. The NOW() function will be ahead by 1 hour.

Environment

Tableau Desktop 10.5, 10.5.1, 10.5.2
Windows 7 or later
MS SQL Server 2012

Resolution

Upgrade to Tableau Desktop 10.5.3 or later version. For more information, see Upgrade Tableau Desktop.

Cause

In earlier version of Tableau Desktop, the NOW() function takes the Daylight Saving Time (DST) selection from user's device, despite UTC-8 Ulaanbaatar no longer observing DST.

Additional Information

Daylight Saving Time (DST) has not been observed since 2018 for Region Ulaanbaatar (Mongolia). Ulaanbaatar currently observes Ulaanbaatar Time (ULAT) all year. The last DST change in Ulaanbaatar was on September 23, 2016.

Discuss this article... Feedback Forum