tencent cloud

Feedback

Time Value Processing Functions

Last updated: 2022-04-19 16:22:15

    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"}
    
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support