Skip to main content
info
This documentation is for version v2.5 of the product.
For the latest version(v2.7) documentation click here
Version: v2.5 print this page

UnixTimeToString

This node converts Unix Time to String

Type

transform

Fields

NameTitleDescription
inputColNameInput Column Nameinput column name
outputColNameOutput Column NameOutput Column Name
outputColFormatOutput Column FormatOutput 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

idunix_time
IntegerTypeLongType
01326483000
11386621000
21392669000

Parameters

NameValue
Input Column Nameunix_time
Output Column Nameunixtime_to_string
Output Column Formatyyyy-MM-dd

Output

idunix_timeunixtime_to_string
IntegerTypeLongTypeStringType
013264830002011-01-01
113866210002012-01-14
213926690002013-12-10