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
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.
Right click the ‘Text’ column ->Transform ->Datatype.
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.
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.