Forum PHP Romania - Discutii despre PHP, MySQL, Javascript, AJAX, etc

[gogu19]

Am in baza de date inregistrate niste date si orele corespunzatoare.Ma intereseaza sa iau nr de inregistrari la un interval de 15 minute(sa fac o grupare dupa acest interval)


Ceva de genul:select count(*),data,intervalul de 15 minute from tbl where conditii group by data,intervalul de 15 minute

Ms

[Birkoff]

group by INTERVAL(N,N1,N2,N3,...)
http://dev.mysql.com/doc/refman/4.1/en/comparison-operators.html#function_interval

[gogu19]

Ms frumos,inca nu stiam de interval()

[gogu19]

SELECT substring( `CDB Timepoint` , 1, 10 ) as data, substr( `CDB Timepoint` , 15, 5 ) as ora,count( * )
FROM cdr_bams.bams_08_06
WHERE `ITU Calling Number Nature of Address` =4
AND `ITU Called Number Nature of Address` =3 and substr( `CDB Timepoint` , 15, 5 ) in (interval(''))
GROUP BY substring( `CDB Timepoint` , 1, 10 ) , substr( `CDB Timepoint` , 15, 5 )

Nu stiu exact cum sa fac interogarea.Ma mai ajuti putin?

Ms

[gogu19]

Nimeni nici o idee? :cry:

[Birkoff]

times > (SELECT DATE_SUB(NOW(), INTERVAL '15' MINUTE))

dar tabela times tre sa fie o tabela care sa contina o valoare in format data sau ora sau timestamp

[gogu19]

Da,dar in baza de date am datele de pe o luna intreaga,si pe fiecare data aprox 300 inregistrari.Ma int sa fac un group by in fctie de data si de ora,din 15 in 15 minute.Cu date_add(interval) nu prea merge...

[PHPRomania Bot]