topic Formatting DateTime string with milliseconds in Discussions

Formatting DateTime string with milliseconds

uProf — Wed, 10 Sep 2025 22:34:41 GMT

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

Re: Formatting DateTime string with milliseconds

Da_Li — Wed, 10 Sep 2025 23:16:44 GMT

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

Re: Formatting DateTime string with milliseconds

uProf — Wed, 10 Sep 2025 23:51:17 GMT

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

uProf — Thu, 11 Sep 2025 03:37:49 GMT

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

hogi — Thu, 11 Sep 2025 13:41:30 GMT

Issues with DATE/TIME Import in JMP?

-> Go to the JMP Prioritization Survey

... and vote: