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

StringToUnixTime

This nodes converts a string to Unix Time

Type

transform

Fields

NameTitleDescription
inputColNameInput Column NameInput Column Name
inputColFormatInput Column FormatInput Column Format (eg: yyyy-MM-dd HH:mm:ss)
outputColNameOutput Column NameOutput Column Name

Details

This node converts a string column to unix time (seconds).

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: Date (string), Format , Unix time (seconds) 2003-07-25 , yyy-MM-dd , 1059091200

Input

iddate_stringdate_string1
IntegerTypeStringTypeStringType
02011-1-1 00:00:00.005/26/2016 01:01:01
12012-1-14 01:00:00.006/22/2017 01:00:00
22013-12-10 02:00:00.001/12/2016 01:01:01

Parameters

NameValue
Input Column Namedate_string
Input Column Formatyyyy-MM-dd HH:mm:ss
Output Column Nameunix_time

Output

iddate_stringdate_string1unix_time
02011-1-1 00:00:00.005/26/2016 01:01:011293840000
12012-1-14 01:00:00.006/22/2017 01:00:001326502800
22013-12-10 02:00:00.001/12/2016 01:01:011386640800