1 Reply Latest reply on Jan 19, 2019 11:01 PM by Dmitry Chirkov

    Custom SQL to convert time field to VARCHAR(8)

    Amrit Sharma

      I am trying to import data from a SQL table in Google BigQuery into Tableau Desktop. Let's say my table has 4 columns: user, date, time and value. I have been to  to write a custom SQL to get all the columns EXCEPT for time. Tableau Support tells I need to convert time to VARCHAR(8) in order for it work. Can you help me do that?

       

      How can I change this SQL to convert time field to VARCHAR(8)?

      SELECT user, date, time, value FROM mytable;

       

      Thanks.