6 Replies Latest reply on Feb 15, 2017 6:38 PM by Sugianto Lauw

    Converting a date column from varchar to date

    Sugianto Lauw

      Hi All,

       

      I am in the middle of trying to use a time stamp column called date_stamp which comes from live connection to Teradata database.

       

      The problem is that date_stamp column is in varchar.

       

      When I tried to change the format which was automatically set on String to Date & Time, it didnt like it. It gives me an error when updating the data source ("Invalid Timestamp").

       

      Now, I am trying to use custom sql to convert this but to no avail. Its giving me "Invalid Timestamp" error again.

       

      With the date_stamp column, here is how it looks like:

       

      2017-02-07 21:07:55+11

       

      Any of you know how to work this out?

       

      Much appreciated for the help in advance.

       

      Best,

       

      Sugi