Function name | Remarks |
---|---|
TO_DATETIME(dateTimeStr, formatStr) |
Converts the specified string representation of a date and time (dateTimeStr) to DateTime using the specified format (formatStr). The list of available format specifiers is here: Custom Date and Time Format Strings. Examples: TO_DATETIME(time, "y/MM/dd HH:mm:ss") TO_DATETIME(date, "yyyy-MM-ddTHH:mm:ss.fffffffZ") |
HEX_TO_INT(hexStr) |
Converts the hex string representation of integer value to Integer value.
Examples: HEX_TO_INT("F3A7") HEX_TO_INT(hexCapture) |
TRIM(str) | Cuts insignificant spaces from the beginning and the end of the specified string. Insignificant spaces are '\t', '\n', '\r', ' '. |
PARSE_YEAR(stringYear) |
Converts the specified value to integer value. Then the value is processed this way:
|
EPOCH_TIME(intEpochTime) | Converts integer epoch time (Unix time) to DateTime object. |
SOURCE_TIME() | Returns the DateTime that represents the last modification time of the log file. |
DATETIME_FROM_TIMEOFDAY(timeOfDayDateTime) | timeOfDayDateTime is DateTime that represents only time information. DATETIME_FROM_TIMEOFDAY() makes complete DateTime object that includes date information. It uses SOURCE_TIME() to take the date of the log. This function is useful for the logs that doesn't store dates, only time of day. |
NEW_LINE() | Returns the string containing new line charachter. |
INPUT_FIELDS_COUNT() | TODO |