2 Replies Latest reply on Feb 17, 2018 9:13 AM by Dharmeswaran Paramasivam

    Time field in Custom SQL

    Dharmeswaran Paramasivam

      Hi,

      I'm new to tableau. I'm trying to import a TIME field from Teradata to tableau. By default its append DATE '12/30/1899' (in front of TIME).

       

      For example:

      In Teradata table - 13:50:03 (this is a time field)

      In Tableau           - 12/30/1899 1:50:03 PM

       

      I don't want the red highlighted DATE in my column. I have tired to build using custom SQL. However, no luck!

       

      Can you please suggest me a solution in custom SQL way? Appreciated for all your help.