Formatting DateTime string with milliseconds

[#1]

Hi - I am seeking help to figure out how to display data time string in csv file that has format like 2025-08-10 23:47:39.367 to show up correctly in the data table. I have tried custom format but no luck since I could not find anything for millisecond in jmp 17.2

Appreciate any pointers

[#2]

You could set Dec to 3 in Column Info to display millisecond, hope this is what you want.

[#3]

Thanks Da_li! For 1754869659367786, I am getting 11897-05-13T00:00:00 if I do that.

I should be getting

2025-08-10 23:47:39.367

[#4]

Figured out the conversion. I will have to convert the unix epoch from microseconds to seconds, followed by steps mentioned here - https://community.jmp.com/t5/Discussions/Unix-Timestamp-to-Real-Date-time/td-p/14947

Lastly, apply the formatting that Da_li recommended and viola!

[#5]

Issues with DATE/TIME Import in JMP?

-> Go to the JMP Prioritization Survey
Help shape the future of JMP: Take this year’s Wish List Prioritization Survey! 
... and vote: