Community & Support Portal

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.

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.