Convert Character Datetime to numeric - JMP User Community

Choose Language Hide Translation Bar

Level I

Created: Oct 19, 2021 03:05 AM | Last Modified: Jun 10, 2023 07:38 PM (837 views)

I tried the formula scripts posted in other threads with no luck. How to convert timestamp in character to numeric datetime?

1 REPLY 1

Super User

Super User

Created: Oct 19, 2021 06:42 AM | Last Modified: Oct 19, 2021 06:43 AM (824 views) | Posted in reply to message from Pro_DF_2021 10-19-2021

Create a new column
Go into the Col Info dialog and set the format and informat values
Enter the following formula for the new column to convert the character column to a JMP Date Time value
```
Informat( Word( 1, :timestamp, "U" ), "yyyy-mm-dd-Thh:mm:ss" )
```

Jim