KNOWLEDGE BASE

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


Published: 11 Apr 2018
Last Modified Date: 10 Oct 2018

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

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.
Did this article resolve the issue?