Version: v2.5
UnixTimeToString
This node converts Unix Time to String
Type
transform
Fields
Name | Title | Description |
---|---|---|
inputColName | Input Column Name | input column name |
outputColName | Output Column Name | Output Column Name |
outputColFormat | Output Column Format | Output Column Format (eg: yyyy-MM-dd HH:mm:ss) |
Details
This node converts unix time (seconds) to string type.
Examples -------
Format Examples
dd-MM-yy : 31-01-12 dd-MM-yyyy : 31-01-2012 MM-dd-yyyy : 01-31-2012 yyyy-MM-dd : 2012-01-31 yyyy-MM-dd HH:mm:ss : 2012-01-31 23:59:59 yyyy-MM-dd HH:mm:ss.SSS : 2012-01-31 23:59:59.999 yyyy-MM-dd HH:mm:ss.SSSZ : 2012-01-31 23:59:59.999+0100 EEEEE MMMMM yyyy HH:mm:ss.SSSZ : Saturday November 2012 10:45:42.720+0100
Example: select an input column (long type), output column name and desired output column format. It will add one more column in string format.
If you input a date format like dd-MM-yy. It will add one column having value like 31-01-12.
Input
id | unix_time |
---|---|
IntegerType | LongType |
0 | 1326483000 |
1 | 1386621000 |
2 | 1392669000 |
Parameters
Name | Value |
---|---|
Input Column Name | unix_time |
Output Column Name | unixtime_to_string |
Output Column Format | yyyy-MM-dd |
Output
id | unix_time | unixtime_to_string |
---|---|---|
IntegerType | LongType | StringType |
0 | 1326483000 | 2011-01-01 |
1 | 1386621000 | 2012-01-14 |
2 | 1392669000 | 2013-12-10 |