KNOWLEDGE BASE

When using the Seconds (Discrete) level, timestamps are rounded instead of truncated


Published: 08 Jul 2019
Last Modified Date: 20 Sep 2019

Issue

When using the Seconds (Discrete) Level from a date-time field drop-down, or DATEPART('second',<Field>) in a calculation, the second is rounded instead of truncated:
 
Date time fieldRoundedTruncated
21/03/2019 01:02:42.6034342
21/03/2019 01:02:43.5544443
21/03/2019 01:02:44.5044544
21/03/2019 01:02:45.4544545
21/03/2019 01:02:46.4054646

Environment

  • Tableau Desktop 2019.2
  • Hyper extracts and flat files

Cause

This behavior is caused by a known issue (ID 942219) that has been fixed in Tableau Desktop 20219.3 and later versions.
Did this article resolve the issue?