899675_en-US

liliconcom

Formatting DateTime string with milliseconds

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

Basic Data Analysis and ModelingRe: Formatting DateTime string with milliseconds

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

 

Re: Formatting DateTime string with milliseconds

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

Re: Formatting DateTime string with milliseconds

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!

Re: Formatting DateTime string with milliseconds

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: