Skip to main content
`Ctrl`+`K`

# 7.15.27. `time_classify_day`

## 7.15.27.1. Summary

New in version 6.0.3.

`time_classify_day` rounds time to a day unit.

This rounded `2020-01-30 11:50:11.000000` and `2020-01-30 22:50:11.000000` to `2020-01-30 00:00:00.000000`.

To enable this function, register `functions/time` plugin by the following command:

    plugin_register functions/time

## 7.15.27.2. Syntax

This function has only one parameter:

    time_classify_day(time)

## 7.15.27.3. Usage

Here are a schema definition and sample data to show usage.

You need to register `functions/time` plugin at first:

Execution example:

    plugin_register functions/time
    # [[0, 1337566253.89858, 0.000355720520019531], true]

Here is a schema definition and sample data.

Sample schema:

Execution example:

    table_create Sales TABLE_NO_KEY
    # [[0, 1337566253.89858, 0.000355720520019531], true]
    column_create Sales name COLUMN_SCALAR ShortText
    # [[0, 1337566253.89858, 0.000355720520019531], true]
    column_create Sales price COLUMN_SCALAR UInt32
    # [[0, 1337566253.89858, 0.000355720520019531], true]
    column_create Sales timestamp COLUMN_SCALAR Time
    # [[0, 1337566253.89858, 0.000355720520019531], true]

Sample data:

Execution example:

    load --table Sales
    [
    {"name": "Apple" , "price": "256", "timestamp": "2020-05-01 11:50:11.000000"},
    {"name": "Apple" , "price": "256", "timestamp": "2020-05-01 10:20:00.000000"},
    {"name": "Orange", "price": "122", "timestamp": "2020-05-01 11:44:12.000001"},
    {"name": "Apple" , "price": "256", "timestamp": "2020-05-01 19:50:23.000020"},
    {"name": "Banana", "price": "88" , "timestamp": "2020-05-01 11:00:02.000000"},
    {"name": "Banana", "price": "88" , "timestamp": "2020-05-01 21:34:12.000001"}
    ]
    # [[0, 1337566253.89858, 0.000355720520019531], 6]

Here is a simple usage of `time_classify_day`:

Execution example:

    select \
      --table Sales \
      --output_columns 'name, time_classify_day(timestamp)'
    # [
    #   [
    #     0,
    #     1337566253.89858,
    #     0.000355720520019531
    #   ],
    #   [
    #     [
    #       [
    #         6
    #       ],
    #       [
    #         [
    #           "name",
    #           "ShortText"
    #         ],
    #         [
    #           "time_classify_day",
    #           null
    #         ]
    #       ],
    #       [
    #         "Apple",
    #         1588258800.0
    #       ],
    #       [
    #         "Apple",
    #         1588258800.0
    #       ],
    #       [
    #         "Orange",
    #         1588258800.0
    #       ],
    #       [
    #         "Apple",
    #         1588258800.0
    #       ],
    #       [
    #         "Banana",
    #         1588258800.0
    #       ],
    #       [
    #         "Banana",
    #         1588258800.0
    #       ]
    #     ]
    #   ]
    # ]

## 7.15.27.4. Parameters

### 7.15.27.4.1. Required parameters

There is only one required parameter.

#### 7.15.27.4.1.1. `column`

Specify a target column.

## 7.15.27.5. Return value

It returns a value that rounded time to a day unit.

The return value is UNIX time.