tencent cloud

masukan

Time Value Processing Functions

Terakhir diperbarui:2024-01-20 17:44:35

    Overview

    CLS's time processing functions include functions for converting date values to string values, converting time field values to UTC time values and vice versa, and getting the current time.

    Function dt_str

    Function definition

    This function is used to convert a time field value (a date string in a specific format or timestamp) to a target date string of a specified time zone and format.

    Syntax description

    dt_str(Value, format="Formatted string", zone="")

    Parameter description

    Parameter
    Description
    Parameter Type
    Required
    Default Value
    Value Range
    data
    Field value. For the parsing formats supported, see dateparser.
    string
    Yes
    -
    -
    format
    Formatted date. For more information, see DateTimeFormatter.
    string
    No
    -
    -
    zone
    Default UTC time, without a specified time zone. For time zone definitions, see ZoneId.
    string
    No
    UTC+00:00
    -

    Example

    Raw log:
    {"date":"2014-04-26 13:13:44 +09:00"}
    Processing rule:
    fields_set("result", dt_str(v("date"), format="yyyy-MM-dd HH:mm:ss", zone="UTC+8"))
    Processing result:
    {"date":"2014-04-26 13:13:44 +09:00","result":"2014-04-26 12:13:44"}

    Function dt_to_timestamp

    Function definition

    This function is used to convert a time field value (a date string in a specified format; time zone specified) to a UTC timestamp.

    Syntax description

    dt_to_timestamp(Value, zone="")

    Parameter description

    Parameter
    Description
    Parameter Type
    Required
    Default Value
    Value Range
    data
    Field value. For the parsing formats supported, see dateparser.
    string
    Yes
    -
    -
    zone
    UTC time is used by default, without a time zone specified. If you specify a time zone, make sure that it corresponds to the time field value. Otherwise, a time zone error occurs. For time zone definitions, see ZoneId.
    string
    No
    UTC+00:00
    -

    Example

    Raw log:
    {"date":"2021-10-26 15:48:15"}
    Processing rule:
    fields_set("result", dt_to_timestamp(v("date"), zone="UTC+8"))
    Processing result:
    {"date":"2021-10-26 15:48:15","result":"1635234495000"}

    Function dt_from_timestamp

    Function definition

    This function is used to convert a timestamp field value to a time string in the specified time zone.

    Syntax description

    dt_from_timestamp(Value, zone="")

    Parameter description

    Parameter
    Description
    Parameter Type
    Required
    Default Value
    Value Range
    data
    Field value. For the parsing formats supported, see dateparser.
    string
    Yes
    -
    -
    zone
    Default UTC time, without a specified time zone. For time zone definitions, see ZoneId.
    string
    No
    UTC+00:00
    -

    Example

    Raw log:
    {"date":"1635234495000"}
    Processing rule:
    fields_set("result", dt_from_timestamp(v("date"), zone="UTC+8"))
    Processing result:
    {"date":"1635234495000","result":"2021-10-26 15:48:15"}

    Function dt_now

    Function definition

    This function is used to obtain the current datetime of the processing calculation.

    Syntax description

    dt_now(format="Formatted string", zone="")

    Parameter description

    Parameter
    Description
    Parameter Type
    Required
    Default Value
    Value Range
    format
    Formatted date. For more information, see DateTimeFormatter.
    string
    No
    -
    -
    zone
    Default UTC time, without a specified time zone. For time zone definitions, see ZoneId.
    string
    No
    UTC+00:00
    -

    Example

    Raw log:
    {"date":"1635234495000"}
    Processing rule:
    fields_set("now", dt_now(format="yyyy-MM-dd HH:mm:ss", zone="UTC+8"))
    Processing result: (The actual processing result depends on the system time, and the following is for reference only.)
    {"date":"1635234495000","now":"2021-MM-dd HH:mm:ss"}
    
    Hubungi Kami

    Hubungi tim penjualan atau penasihat bisnis kami untuk membantu bisnis Anda.

    Dukungan Teknis

    Buka tiket jika Anda mencari bantuan lebih lanjut. Tiket kami tersedia 7x24.

    Dukungan Telepon 7x24