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

Published: 11 Apr 2018
Last Modified Date: 11 Jan 2019


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.


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


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