This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.