(RADIATOR) formatted TIME_STAMP in AcctSQLStatement

Brian Morris brian at netspeed.com.au
Sun Sep 21 08:10:57 CDT 2003


I would suggest that you use

formatted-date,'%Y %m %e %H:%M:%S'

That way you can treat is as a numeric for sorting / searching etc.

Cheers,

Brian Morris
NetSpeed.



----- Original Message ----- 
From: "Robert Blayzor" <noc at inoc.net>
To: "tracker" <jaws at skyinet.net>; "Radiator" <radiator at open.com.au>
Sent: Thursday, September 11, 2003 10:09 PM
Subject: Re: (RADIATOR) formatted TIME_STAMP in AcctSQLStatement


> On 9/11/03 7:23 PM, "tracker" <jaws at skyinet.net> wrote:
>
> > Is it possible to use a formatted TIME_STAMP in AcctSQLStatement, like
> >
> > formatted-date,'%e %m %Y %H:%M:%S'
>
> Easier way may be to have your SQL server insert the time for you.  That
is,
> if your SQL server and your RADIUS server's times are sync'd.  (and
current
> date/time is what you want)  You can do this several ways depending on
your
> backend, ie:
>
> MSSQL - getdate()
>
> Or PgSQL - timestamp 'now'
>
> More..
>
> INSERT INTO tbl_radacct (recdate) values (timestamp 'now')
>
> --
> Robert Blayzor, BOFH
> INOC, LLC
> rblayzor at inoc.net
> PGP: http://www.inoc.net/~dev/
> Key fingerprint = A445 7D1E 3D4F A4EF 6875  21BB 1BAA 10FE 5748 CFE9
>
> I'm not sure.  Try calling the Internet's head office -- it's in the book.
>
>
> ===
> 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.
>

===
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.


More information about the radiator mailing list