Reading timestamp datatype from Amazon Athena
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
YipengTang
6 - Meteoroid
‎02-21-2024
08:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Labels:
- Labels:
- Date Time
- In Database
- Input
- Output
1 REPLY 1
21 - Polaris
‎02-21-2024
08:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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?
