How to write a statement to make queries every 15 minutes to take a record, the record and the colum-CodePudding

CodePudding

Home > database > How to write a statement to make queries every 15 minutes to take a record, the record and the colum

How to write a statement to make queries every 15 minutes to take a record, the record and the colum

Time：09-27

Consult,

, the original database records the following
Every minute a record

CodePudding user response:

How to write a statement to make queries every 15 minutes to take a record, the record and the column is the average of the 15 minutes all the records, the original database tables for a record every minute

CodePudding user response:

Group by to_char (rectime, 'yyyyMMddHH), date_part (' minute' rectime) : : int/15

Page link：https//www.codepudding.com/database/37364.html

Prev:Mysql export text field data to excel data is incomplete

Next:How to remove the Spaces in the shell script exported TXT documents

Tags：

PostgreSQL

Links：
CodePudding