if you run this script, it should fix your LogingTime data
Names default to here(1);
For Each Row(
:loggingTime = Substr( :loggingTime, 1, 23 );
);
Formats will automatically loop through each row, but scripts require one to do the looping within the script.
Concerning your informat issue....Here is a format that if you create a new column, and specify the below as the format, it will convert your LoggingTime to a JMP date time value. All you need to do then, is to specify the DateTime format you want to use for the displaying of the value
num(format(informat(date,"yyyy-mm-dd h:m:s"),"fixed dec",23,3))
Jim