8 Replies Latest reply on Mar 2, 2016 9:57 AM by Rody Zakovich

    Combine Date and String Fields to Create a Timestamp

    Nicholas DiBella

      I have two fields in my table (stored in an Oracle database) called: Effective Date, and Time of Day. Effective Date is stored as a Date datatype and Time of Day is stored as a VARCHAR2(6 BYTE) in my table.

       

      I am looking to see if it is possible to combine these two fields in order to create a new Time-stamp field. That way, I would be able to create a continuous time-series in Tableau.

       

      Any type of input would be greatly appreciated.

       

      Thanks!