On Tue, 3 Aug 1999, David Booth wrote:
> 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?
I just store the stop_time and the call_duration in our sql table; storing
the start_time as well would be redundant. Rather than performing the
calculation at insert time, I just calculate it at query time if I
need it.
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.