Hallo
I have a table with 9 colums
serial | cli | cld | connect_time | metric | chargetime | charge |destination |de_charge
I want for each serial to chargetime /60 and * with de_charge
For each serial for all serials and if is able to can add between dates
IF someone can help me i will gratefull
Thanks very much
Complicate math problem :D
Moderator: General Moderators
Re: Complicate math problem :D
What?I want for each serial to chargetime /60 and * with de_charge
For each serial for all serials and if is able to can add between dates

Re: Complicate math problem :D
hahah sorry 
I upload a demo of the file it inside a mysql table
I want for each serial somehow take chargetime division with 60 and propagation with de_charge number
Thanks
I upload a demo of the file it inside a mysql table
I want for each serial somehow take chargetime division with 60 and propagation with de_charge number
Thanks
- Attachments
-
- cdr.zip
- (18.85 KiB) Downloaded 342 times
Re: Complicate math problem :D
So, what's the problem with (chargetime/60)*de_charge ?
Re: Complicate math problem :D
SELECT serial
, chargetime / 60 * de_charge AS result
FROM daTable
I forgot to mention the problem is how can i make it work between dates i have a colum with dates too
, chargetime / 60 * de_charge AS result
FROM daTable
I forgot to mention the problem is how can i make it work between dates i have a colum with dates too
Re: Complicate math problem :D
SELECT serial
, chargetime / 60 * de_charge AS result
FROM daTable
where connect_time between 'date' and 'date
, chargetime / 60 * de_charge AS result
FROM daTable
where connect_time between 'date' and 'date