PHP kôd:
SELECT FROM_UNIXTIME(timestamp, '%k') h, MIN(value), MAX(value) FROM dpt GROUP BY h;
PHP kôd:
SELECT HOUR(FROM_UNIXTIME(timestamp, '%H:%i:%s')) h, MIN(value), MAX(value) FROM dpt GROUP BY h;
amidoinitrite?
Dodaj tamo WHERE ako hoćeš za neki dan, i tako...
Citat:
h MIN(value) MAX(value)
0 3 977
1 15 908
2 116 962
3 46 922
4 126 984
5 78 997
6 193 995
7 61 988
8 16 984
9 16 844
10 57 922
11 25 991
12 23 991
13 11 857
14 43 972
15 9 927
16 51 983
17 49 868
18 188 986
19 59 690
20 58 999
21 91 973
22 122 958
23 61 791
|