cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
Pro_DF_2021
Level I

Convert Character Datetime to numeric

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

Pro_DF_2021_0-1634626970198.png

 

1 REPLY 1
txnelson
Super User

Re: Convert Character Datetime to numeric

  1. Create a new column
  2. Go into the Col Info dialog and set the format and informat values                                                      txnelson_0-1634640004507.png
  3. 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" )
    txnelson_2-1634640223308.png

     

Jim