| 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 |