2 Replies Latest reply on Mar 27, 2013 7:04 AM by Catherine Williams

    Combining date with time field stored as a string

    Catherine Williams

      I'm connecting Tableau to a SQL database which has Time stored as data type: time(7) which defaults to a string data type and appears in this format: 02:32:18.0000000.  I'd like to combine this time field with a date field to create a date time field.  If I change the datatype in Tableau of the Time field it returns Null for anything other than a string.

       

      Any advice much appreciated.