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.