ifthenelse(length(timestamp_str) = 19, parse("yyyy/MM/dd hh:mm:ss", timestamp_str), ifthenelse(timestamp_str -> " ", parsedate(timestamp_str, dateformat("MMM D HH:mm:ss YYYY", "UTC")), parsedate(timestamp_str, dateformat("MMM DD HH:mm:ss YYYY", "UTC")))) |