1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
plugin_register functions/time
table_create Records TABLE_NO_KEY
column_create Records timestamps COLUMN_VECTOR Time
load --table Records
[
{"timestamps": ["2016-04-30 23:59:59.999999"]},
{"timestamps": ["2016-05-01 00:00:00.000000"]},
{"timestamps": ["2016-05-01 00:00:00.000001"]},
{"timestamps": ["2016-05-07 23:59:59.999999"]},
{"timestamps": ["2016-05-08 00:00:00.000000"]},
{"timestamps": ["2016-05-08 00:00:00.000001"]}
]
select Records \
--sort_keys _id \
--limit -1 \
--output_columns 'timestamps, time_classify_week(timestamps)'
|
