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.