Changing data type from character to continuous with JSL

[#1]

I have a script that gets back the time as character. The format is correct but I want  to automate this change of data type automatically.

How to do so in JSL scripting?

[#2 · Accepted solution]

From the screenshot you are displaying, it appears that whatever methodology you are using to generate the TS_UTC column, that it is being generated as a character column.  The following JSL will convert from your character column to a numeric, continuous column, with your desired display format.

names default to here(1);
dt=current data table();
dt:TS_UTC<<data type(numeric)<<modeling type(continuous)<<format("yyyy-mm-ddThh:mm:ss");