1 2 Previous Next 21 Replies Latest reply on Oct 12, 2013 11:20 PM by Prem Reddy

    SQL time fields not appearing in Tableau

    Robert Royer

      I am running Tableau Pro 7.0, accessing SQL 2008 R2 (64-bit). Our SQL Database has a variety of data types and most appear to pull into Tableau just fine. One of our fields is a TIME data type in SQL. The field does not show in Tableau once we connect to the datasource. In SSMS, I have verified the field does in fact exist and is populated with time-only stamps (##:##:##). Other date and datetime fields pull into Tableau without error.

       

      I know in the "Change Data Type" option, Tableau lists: Number, Date & Time, Date, and String as options. Does Tableau not support the TIME-only data type?

        1 2 Previous Next