(RADIATOR) Mysql and time stamp

[Hugh Irvine]

Hello -

The Radiator Timestamp is the standard Unix time which is the number of 
seconds since January 1 1970.

Many SQL databases know how to do queries with these - otherwise you 
can convert them to whatever format suits.

You should check your database documentation and/or a good book on SQL.

regards

Hugh


On 30 Mar 2004, at 23:47, Tech wrote:

> I am trying to do a command line sql statement to find the total time 
> for all users that had logged  in  for  between 28/01/2004 and say 
> 30/03/2004 returning say username total time in hours,min.ss
> and date of each login from  using the Radiator time_stamp .
>
> any help please
>
> best regards
>
> --
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.