String To Unix Time¶
This node converts a string to Unix Time
Type¶
transform
Class¶
fire.nodes.etl.NodeStringToUnixTime
Fields¶
Name |
Title |
Description |
|---|---|---|
inputColName |
Input Column Name |
Input Column Name |
inputColFormat |
Input Column Format |
Input Column Format (eg: yyyy-MM-dd HH:mm:ss) |
outputColName |
Output Column Name |
Output Column Name |
Details¶
String To Unix Time Details¶
This node converts a string column to unix Timestamp.
Input¶
INPUT COLUMN NAME :- The input column is selected here and it should be of string datatype.
INPUT COLUMN FORMAT :- The format of input column must be specified here
OUTPUT COLUMN NAME :- Name of output column is specified here.
Output¶
Converts the string value to Unix timestamp
Example¶
INPUT value:-2011-01-30
INPUT COLUMN FORMAT :-yyyy-mm-dd
OUTPUT value would be 1296345660 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