Convert timestamp based text formats to Timestamp Print
Modified on: Mon, 12 Oct, 2020 at 8:51 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.
Modified on: Mon, 12 Oct, 2020 at 8:51 PM
Did you find it helpful? Yes No
Send feedback
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:
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.