Examples

Target field Code type Code Comments
Time Expression
TO_DATETIME(time, "y/MM/dd HH:mm:ss")

Functions reference

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:
  • If the value is greater than 100, it is returned as is.
  • If the value is greater than 60, (2000 + year) is returned.
  • (1900 + year) is returned otherwise.
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