community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Milliseconds - Need Help!

Alteryx Certified Partner
Alteryx Certified Partner

Hi Community,

I need help on how I can use the millisecond part of a DateTime field (or Timestamp).

I tried all I know, and couldn't find a way to have those $&#@+! milliseconds on my data.

 

Thanks a lot for any idea you can give me...

I believe Alteryx stores datetimes as 'yyyy-MM-dd hh:mm:ss' so the built in type wont help.

 

I suggest you read in milliseconds in a separate column. For example if coming from SQL Server use the DatePart function to extract the millisecond:

SELECT TOP 1 SYSDATETIME() as sysTime, DATEPART(ms, SYSDATETIME()) as milliSecond from DiaryEvents

You could convert them to millisecond from a epoc. E.g. Milliseconds since 1-Jan-1970 00:00:00 but then you wont be able to use any of the bullt in date functions to help much.

 

 

 

 

Labels