Convert timestamp based text formats to Timestamp

Modified on Mon, 12 Oct, 2020 at 8:51 PM

Convert a Timestamp like '20190301175527', which is shown as a text column in the dataset to Timestamp


Solution:

The timestamp based texts will be varied based on the timestamp formats from which it was converted. The following are few examples of the timestamp formats that got converted to string formats.


String

Timestamp

20190301175527 

yyyyMMddHHmmss

1632300000

yyMddHmmss

616031200

MYYddhms

Procedure

  1. Right click the ‘Text’ column ->Transform ->Datatype.


  

                                                TRANSFORM OPERATION

 

        2. Select the New data type as TimeStamp.

        3. In the Timestamp format input section, select ‘yyyyMMddHHmmss’ if you want 24 hours format (where HH= Hours for 24 hour format, MM = Month and mm = minutes). Choose ’yyyyMMddhhmmss’ if you want to display in 12 hour format. There are many other formats available as shown in the below screen, and click APPLY


                        TRANSFORMING DATATYPE TO 24 HOUR FORMAT

The text will be converted to Timestamp as displayed below.

 

 

     THE OUTPUT


Note: This article is based on Smarten Version 5.0. This may or may not be relevant to the Smarten version you may be using.




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article