I have a timestamp with this format
"2024-01-01T20:00:00.190000000Z"
I can convert this to normal format using rex, however, I want to know is there a alternative to convert to normal time format?
There are many formats that someone would consider "normal". Almost none of them require rex. Use the strptime and strftime functions to convert one time format to another.
| eval ts = strftime(strptime(ts, "%Y-%m-%dT%H:%M:%S.%9N%Z"), "<<your 'normal' format>>")