I collect stop records and insert into a mySQL table. I want a column for intime (type datetime) that should be:
intime = Timestamp - Acct-Session-Time
I'm using a temp table for the radius log and a mySQL INSERT to my table because when I try to insert with the calculation I get a lot of zero or empty entries.
Anyone have any experience with this kind of calculation?