In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Reading timestamp datatype from Amazon Athena

YipengTang
6 - Meteoroid

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?

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@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?

2024-02-22 133432.png2024-02-22 133637.png

Labels
Top Solution Authors