1 Reply Latest reply on Jun 19, 2013 10:17 PM by Paramesh Sangangiri

    mySQL Time

    Vish Sub

      All,

       

      My Duration data is formatted as below in a MYSQL db as a Time field.. Unfortunately Tableau loads this as  Date Time with 12/30/1889 and then a time stamp. How can i make tableau show the data as-is? I tried converting to string but no use.

       

      thanks.

       

      Date Ticket CreatedDuration
      6/1/2013177:55:27
      6/2/2013181:10:28
      6/3/2013167:28:35
      6/4/2013154:20:00
      6/5/2013181:47:46
      6/6/2013146:55:02
      6/7/2013133:07:49
      6/8/2013181:14:32
      6/9/2013178:03:27
      6/10/2013162:00:09
      6/11/2013181:59:48
      6/12/2013179:33:38
      6/13/2013171:16:09
      6/14/2013181:18:22
      6/15/2013188:43:02
      6/16/2013179:59:00
      6/17/2013177:01:22