We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Date Time conversion

Alteryx_Geek
8 - Asteroid
‎07-27-2022 09:16 AM

How do I achieve the below output for Date Time format

 

2021-05-12 14:07:04.441932 = 14:07:04  (when decimal is < 0.5 msec then same digit in second)
2021-05-12 14:07:04.847982 = 14:07:05  (When decimal is >= 0.5 msec then next digit in second

 

Thanks

Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

10 REPLIES 10
binuacs
21 - Polaris
‎07-27-2022 10:38 AM

@Alteryx_Geek updated the workflow

 

binuacs_0-1658943470860.png

 

DateTime1_27_07.yxmd
Reply
Labels
Top Solution Authors
View All