topic Re: Convert Character Datetime to numeric in Discussions

topic Re: Convert Character Datetime to numeric in Discussions https://community.jmp.com/t5/Discussions/Convert-Character-Datetime-to-numeric/m-p/428180#M67753 <OL> <LI>Create a new column</LI> <LI>Go into the Col Info dialog and set the format and informat values                                                      <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="txnelson_0-1634640004507.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/36824i1EAED4CB614DF8AD/image-size/medium?v=v2&px=400" role="button" title="txnelson_0-1634640004507.png" alt="txnelson_0-1634640004507.png" /></span></LI> <LI>Enter the following formula for the new column to convert the character column to a JMP Date Time value <PRE><CODE class=" language-jsl">Informat( Word( 1, :timestamp, "U" ), "yyyy-mm-dd-Thh:mm:ss" )</CODE></PRE> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="txnelson_2-1634640223308.png" style="width: 713px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/36826i6A6E94B809904AEB/image-dimensions/713x189?v=v2" width="713" height="189" role="button" title="txnelson_2-1634640223308.png" alt="txnelson_2-1634640223308.png" /></span> <P> </P> </LI> </OL> Tue, 19 Oct 2021 10:43:56 GMT txnelson 2021-10-19T10:43:56Z Convert Character Datetime to numeric https://community.jmp.com/t5/Discussions/Convert-Character-Datetime-to-numeric/m-p/428112#M67746 <P>I tried the formula scripts posted in other threads with no luck. How to convert timestamp in character to numeric datetime? </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Pro_DF_2021_0-1634626970198.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/36820i0ACAAC8BFA553C48/image-size/medium?v=v2&px=400" role="button" title="Pro_DF_2021_0-1634626970198.png" alt="Pro_DF_2021_0-1634626970198.png" /></span></P><P> </P> Sat, 10 Jun 2023 23:38:46 GMT https://community.jmp.com/t5/Discussions/Convert-Character-Datetime-to-numeric/m-p/428112#M67746 Pro_DF_2021 2023-06-10T23:38:46Z Re: Convert Character Datetime to numeric https://community.jmp.com/t5/Discussions/Convert-Character-Datetime-to-numeric/m-p/428180#M67753 <OL> <LI>Create a new column</LI> <LI>Go into the Col Info dialog and set the format and informat values                                                      <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="txnelson_0-1634640004507.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/36824i1EAED4CB614DF8AD/image-size/medium?v=v2&px=400" role="button" title="txnelson_0-1634640004507.png" alt="txnelson_0-1634640004507.png" /></span></LI> <LI>Enter the following formula for the new column to convert the character column to a JMP Date Time value <PRE><CODE class=" language-jsl">Informat( Word( 1, :timestamp, "U" ), "yyyy-mm-dd-Thh:mm:ss" )</CODE></PRE> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="txnelson_2-1634640223308.png" style="width: 713px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/36826i6A6E94B809904AEB/image-dimensions/713x189?v=v2" width="713" height="189" role="button" title="txnelson_2-1634640223308.png" alt="txnelson_2-1634640223308.png" /></span> <P> </P> </LI> </OL> Tue, 19 Oct 2021 10:43:56 GMT https://community.jmp.com/t5/Discussions/Convert-Character-Datetime-to-numeric/m-p/428180#M67753 txnelson 2021-10-19T10:43:56Z