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.