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

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 field	Rounded	Truncated
21/03/2019 01:02:42.603	43	42
21/03/2019 01:02:43.554	44	43
21/03/2019 01:02:44.504	45	44
21/03/2019 01:02:45.454	45	45
21/03/2019 01:02:46.405	46	46

Environment

Tableau Desktop 2019.2
Hyper extracts and flat files

Resolution

Upgrade to Tableau Desktop 2019.3 or a newer version. See Tableau Desktop Downloads and Release Notes for downloads of current and previous versions of Tableau Desktop. For more information on current releases, see Upgrade Tableau Desktop and Desktop Upgrade.