Reading timestamp datatype from Amazon Athena

YipengTang

In the Athena view, I have a table with fields that have timestamp data type, YYYY-mm-dd HH:MM:SS:mmm, while 'mmm' is milliseconds.   

After I read it into Alteryx, the 'mmm' was missing (dropped automatically),

I am wondering how I can keep 'mmm' in the Alteryx?

Qiu

@YipengTang 
If you are using Alteryx version 2023.1, it should be able to read the millisecond as DateTime format.

But the delimeter is a ".", rather than the ":" in your data.

Maybe you can try to read in the data as String and then replace the delimeter?