In Snowflake, I have dates in TZ format that I have to convert to regular timestamp without milliseconds. I did some operation, but the output turns out wrong.

Input:

2018-08-12T20:17:46.384Z

Output:

2018-08-12 20:17:46

This is what I did on column ‘Time’.

TO_CHAR(Time::Timestamp yyyy-mm-dd hh:mm:ss)

This produces time in the mentioned format, however the values are wrong. I failed to identify what is the issue. Any help is appreciated.