Hi,
I have a request that group data in hour intervals :
BEGIN
RETURN
'SELECT TO_CHAR(trunc(DATE1, '''||:P24_TRUNC||'''), ''DD/MM/YYYY HH24:MI'') "Date", ROUND(AVG(VALEUR),2) "Valeur" FROM EVV_'||:P24_EQUIPEMENT||'
WHERE CLEF_VAR =
(SELECT CLEF_VAR FROM C_VARIABLE WHERE REF_VAR = '''||:P24_REF_VAR||''')
AND TRUNC(DATE1) BETWEEN TO_DATE('''||:P24_DATE_DEBUT||'000000'', ''DD/MM/YYYYHH24MISS'') AND TO_DATE('''||:P24_DATE_FIN||'235959'', ''DD/MM/YYYYHH24MISS'')
GROUP BY TRUNC(DATE1, '''||:P24_TRUNC||''')
ORDER BY TRUNC(DATE1, '''||:P24_TRUNC||''')';
END;
The result is something like that :
| Date | Valeur |
|---|
| 14/03/2019 00:00 | 1,14 |
| 14/03/2019 01:00 | 1,17 |
| 14/03/2019 02:00 | 1,12 |
| 14/03/2019 03:00 | 0,98 |
| 14/03/2019 04:00 | 0,79 |
| 14/03/2019 05:00 | 0,69 |
I would like to group data by 15 minutes interval and the result would be like this :
| Date | Valeur |
|---|
| 14/03/2019 00:00 | 1,14 |
| 14/03/2019 00:15 | 1,17 |
| 14/03/2019 00:30 | 1,12 |
| 14/03/2019 00:45 | 0,98 |
| 14/03/2019 01:00 | 0,79 |
| 14/03/2019 01:15 | 0,69 |
How to do ?
Regards.