Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Add DateTime type with milliseconds

I work with data where milliseconds is my saviour when I count distinct the datetime to get number of events. Alteryx ignores the millisecond part (as lots of other BI tool providers - I don't know what is going on with this idea that milliseconds are not needed). Yes I can convert it to string but it's not the best practice to create duplicate fields just so that I have date part for date-related calculation (plotting, time difference) and on the other hand string value for quick and easy counting..

56 Comments
MsBindy
8 - Asteroid

#4) This is what my data looks like:

2022-10-07 14:58:37.000627

 

And I agree with @Hiblet that we should be able to treat this data like other date data.

ChrisK
Alteryx
Alteryx

@MsBindy What things do you need to do with data like "2022-10-07 14:58:37.000627" What is most important to you?

  1. compute differences between them, add some time units to them?
  2. Sort them into order?
  3. Write them to files? Write them to Databases? (using what field type?)
  4. Read them from files? Read them from Databases?
  5. Format them to human readable dates, like Oct. 7, 2022, 2:58:37.000627 PM ?
  6. Parse them from human readable dates?
  7. Truncate or round them to less precise time, like 14:58:37.001?
  8. Get the current time to higher precision?
  9. Do you ever operate with mis-matched precision? That is, do you have some data in milliseconds and some in nanoseconds, but you need to find the difference between them?
MsBindy
8 - Asteroid

 

I am mainly sorting and subtracting to find out how much time has passed between steps in a process.

 

andrew_macey
5 - Atom

Requested as far back as 2015 https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Milliseconds-Need-Help/td-p/4624

Pretty lame that it even takes upvotes to have this deficiency fixed

TonyaS
Alteryx
Alteryx
Status changed to: Coming Soon

In case folks missed that this was changed to Accepted, it is in progress for implementation in an upcoming Release. I am updating the status to "Coming Soon" to make that more clear. 

 

Those interested in this functionality can help by providing some answers to the questions posed earlier: 

 

What things do you need to do with data like "2022-10-07 14:58:37.000627" What is most important to you?

  1. compute differences between them, add some time units to them?
  2. Sort them into order?
  3. Write them to files? Write them to Databases? (using what field type?)
  4. Read them from files? Read them from Databases?
  5. Format them to human readable dates, like Oct. 7, 2022, 2:58:37.000627 PM ?
  6. Parse them from human readable dates?
  7. Truncate or round them to less precise time, like 14:58:37.001?
  8. Get the current time to higher precision?
  9. Do you ever operate with mis-matched precision? That is, do you have some data in milliseconds and some in nanoseconds, but you need to find the difference between them?
sahartz
8 - Asteroid

Hi @TonyaS  ,

 

The things that I do with this type of data is: 

1. Compute differences between them

2. Sort them into order

4. Read them from DBs

7. Truncate or round them to less precise time

9. Yes