4 Replies Latest reply: May 4, 2016 10:32 PM by Pranav Trivedi RSS

    Text toTimestamp# not working

    Pranav Trivedi

      Hey Guys,

       

      I have an API extracted table which has a column with values similar to this 2016-05-03 10:57:54+12:00. This is text as i tested it using istext() which returned '-1'

       

      I am trying to convert data in this column from Text to Timestamp, so i can split this later into Date and time respectively

       

      I attempted  TimeStamp#(MaxString(<field_Name>,1) ) but the result is still the same "Text" value. it does not return value in 'TimeStamp' Type.

       

      Not sure what i am doing wrong.  my objective is get column with values like 2016-05-03 10:57:54+12:00 to be converted into regular timestamp of local type and use it to split them into Date and time respectively.


      Hope this make sense. Any help will be hugely appreciated.


      Thanks.