# iot-odoo

**Repository Path**: amoserp/iot-odoo

## Basic Information

- **Project Name**: iot-odoo
- **Description**: IOT 物联网
- **Primary Language**: Python
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 7
- **Created**: 2022-08-15
- **Last Updated**: 2023-11-30

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# odoo-iot

#### Description

IOT 物联网

id = 105247

SELECT code, to_char ( time, 'YYYY-MM-DD HH24') as utc_YYYYMMDDHH, count(id), sum(value) / count(id) as avg_value
FROM public.iot_value
where create_date > '2021-01-16 23:59:59'
and code > '000000000009'
group by code, to_char ( time, 'YYYY-MM-DD HH24')
order by code, to_char ( time, 'YYYY-MM-DD HH24') desc;