time series id
时间: 2023-03-25 20:02:44 浏览: 83
时间序列 ID 是指在时间序列分析中,用于标识每个时间点的唯一标识符。它可以是日期、时间戳或其他形式的标识符。在时间序列分析中,时间序列 ID 是非常重要的,因为它可以帮助我们对时间序列数据进行正确的排序和分析。
相关问题
js 把字符串转jsonArray "[{fd_zj_materialCode_dataModelName=, fd_zj_materialCode_dataFdId=, fd_zj_machine_series_code=18, fd_zj_screw=46/B, fd_zj_crm_flag=同步成功, fd_zj_quantity=1.0, fd_zj_delivery_date_record=[{id=16eeff527815c214b0af8404e9e9e1cf, time=Wed Feb 08 17:00:15 CST 2023, name=蓝凌, data=2023-02-13}], fd_zj_materialCode_dataSourceId=, fd_zj_materialCode=2260933346643275, fd_zj_demand_desc_record=[{id=16eeff527815c214b0af8404e9e9e1cf, time=Wed Feb 08 17:00:15 CST 2023, name=蓝凌, data=1、配镀铬混炼B螺杆 2、加装 抽芯一组 3、加装吹风一组}], fd_zj_materialCode_selectedDatas=, fd_zj_crm_flag_record=[{id=16eeff527815c214b0af8404e9e9e1cf, time=Wed Feb 08 17:00:15 CST 2023, name=蓝凌, data=}], fd_zj_remark=, fd_zj_machine_series_desc_record=[{id=16eeff527815c214b0af8404e9e9e1cf, time=Wed Feb 08 17:00:15 CST 2023, name=蓝凌, data=JM168-MK6.6/A注塑机}], fd_zj_materialCode_text=2F800-000000000, fd_zj_quantity_record=[{id=16eeff527815c214b0af8404e9e9e1cf, time=Wed Feb 08 17:00:15 CST 2023, name=蓝凌, data=1.0}], fd_zj_machine_series_desc=JM168-MK6.6/A注塑机, fd_zj_factory_source_record=[{id=16eeff527815c214b0af8404e9e9e1cf, time=Wed Feb 08 17:00:15 CST 2023, name=蓝凌, data=null}, {id=16eeff527815c214b0af8404e9e9e1cf, time=Wed Feb 08 17:02:22 CST 2023, name=蓝凌, data=震德机}], fd_zj_remark_record=[{id=16eeff527815c214b0af8404e9e9e1cf, time=Wed Feb 08 17:00:15 CST 2023, name=蓝凌, data=}], fd_zj_screw_record=[{id=16eeff527815c214b0af8404e9e9e1cf, time=Wed Feb 08 17:00:15 CST 2023, name=蓝凌, data=46/B}], fd_zj_factory_source=3.0, fd_zj_delivery_date=Mon Feb 13 00:00:00 CST 2023, fd_zj_assess=null, fd_zj_demand_desc=1、配镀铬混炼B螺杆 2、加装 抽芯一组 3、加装吹风一组, fdId=18630410f7c0108ea5df44646d5acea6, fd_zj_machine_series_code_record=[{id=16eeff527815c214b0af8404e9e9e1cf, time=Wed Feb 08 17:00:15 CST 2023, name=蓝凌, data=18}]}]"
您可以使用 JSON.parse() 方法将该字符串转换为 JSON 数组,代码如下:
```javascript
var jsonArray = JSON.parse('[{"fd_zj_materialCode_dataModelName":"","fd_zj_materialCode_dataFdId":"","fd_zj_machine_series_code":"18","fd_zj_screw":"46/B","fd_zj_crm_flag":"同步成功","fd_zj_quantity":"1.0","fd_zj_delivery_date_record":[{"id":"16eeff527815c214b0af8404e9e9e1cf","time":"Wed Feb 08 17:00:15 CST 2023","name":"蓝凌","data":"2023-02-13"}],"fd_zj_materialCode_dataSourceId":"","fd_zj_materialCode":"2260933346643275","fd_zj_demand_desc_record":[{"id":"16eeff527815c214b0af8404e9e9e1cf","time":"Wed Feb 08 17:00:15 CST 2023","name":"蓝凌","data":"1、配镀铬混炼B螺杆 2、加装 抽芯一组 3、加装吹风一组"}],"fd_zj_materialCode_selectedDatas":"","fd_zj_crm_flag_record":[{"id":"16eeff527815c214b0af8404e9e9e1cf","time":"Wed Feb 08 17:00:15 CST 2023","name":"蓝凌","data":""}],"fd_zj_remark":"","fd_zj_machine_series_desc_record":[{"id":"16eeff527815c214b0af8404e9e9e1cf","time":"Wed Feb 08 17:00:15 CST 2023","name":"蓝凌","data":"JM168-MK6.6/A注塑机"}],"fd_zj_materialCode_text":"2F800-000000000","fd_zj_quantity_record":[{"id":"16eeff527815c214b0af8404e9e9e1cf","time":"Wed Feb 08 17:00:15 CST 2023","name":"蓝凌","data":"1.0"}],"fd_zj_machine_series_desc":"JM168-MK6.6/A注塑机","fd_zj_factory_source_record":[{"id":"16eeff527815c214b0af8404e9e9e1cf","time":"Wed Feb 08 17:00:15 CST 2023","name":"蓝凌","data":null},{"id":"16eeff527815c214b0af8404e9e9e1cf","time":"Wed Feb 08 17:02:22 CST 2023","name":"蓝凌","data":"震德机"}],"fd_zj_remark_record":[{"id":"16eeff527815c214b0af8404e9e9e1cf","time":"Wed Feb 08 17:00:15 CST 2023","name":"蓝凌","data":""}],"fd_zj_screw_record":[{"id":"16eeff527815c214b0af8404e9e9e1cf","time":"Wed Feb 08 17:00:15 CST 2023","name":"蓝凌","data":"46/B"}],"fd_zj_factory_source":"3.0","fd_zj_delivery_date":"Mon Feb 13 00:00:00 CST 2023","fd_zj_assess":null,"fd_zj_demand_desc":"1、配镀铬混炼B螺杆 2、加装 抽芯一组 3、加装吹风一组","fdId":"18630410f7c0108ea5df44646d5acea6","fd_zj_machine_series_code_record":[{"id":"16eeff527815c214b0af8404e9e9e1cf","time":"Wed Feb 08 17:00:15 CST 2023","name":"蓝凌","data":"18"}]}]');
```
这样,您就可以使用 jsonArray 数组来访问该 JSON 数据了。注意,该字符串中的键名需要使用双引号包裹起来,否则无法正确解析。
SELECT countMinute, dc, COUNT ( 1 ) FROM ( SELECT generate_series ( '2023-06-26' :: TIMESTAMP, '2023-06-30' :: TIMESTAMP, '1 hour' :: INTERVAL ) AS countMinute ) VA LEFT JOIN vc_user_equipment VUE ON countMinute >= VUE.create_time AND countMinute < sign_expiration_time WHERE good_id = 1 AND supplier_type = '2' GROUP BY countMinute,dc order by countminute
您的查询语句如下:
```sql
SELECT countMinute, dc, COUNT(1)
FROM (
SELECT generate_series('2023-06-26'::TIMESTAMP, '2023-06-30'::TIMESTAMP, '1 hour'::INTERVAL) AS countMinute
) VA
LEFT JOIN vc_user_equipment VUE ON countMinute >= VUE.create_time AND countMinute < sign_expiration_time
WHERE good_id = 1 AND supplier_type = '2'
GROUP BY countMinute, dc
ORDER BY countMinute
```
该查询语句的功能是统计在指定时间范围内(从2023年6月26日到2023年6月30日,每小时)符合条件的数据。在`vc_user_equipment`表中,根据`create_time`和`sign_expiration_time`字段的值与每个小时的时间范围进行比较,如果满足条件,则进行计数。最后,按照`countMinute`字段和`dc`字段进行分组,并按照`countMinute`字段进行升序排序。
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)