(RADIATOR) formatted TIME_STAMP in AcctSQLStatement

[Mike McCauley]

Hello,


On Fri, 12 Sep 2003 09:49 am, Robert Blayzor wrote:
> On 9/11/03 7:19 PM, "Mike McCauley" <mikem at open.com.au> wrote:
> > Yes, but you really should take into account the Acct-Delay-Time in
> > accounting requests, which is the amount of time the request has been
> > sitting in the NAS waiting for successful transmission. The Timestamp
> > attrtibute takes this into account, so its best to use that if possible.
>
> If that's the case, could you not just use the "DateFormat" directive from
> the manual, 6.28.18. ?
>
> Since many of us may use stored procedures, AcctColumnDef's don't do a
> whole lot.. ;-)
>
> So lets say I'm using MSSQL...
>
>         DateFormat      %m/%d/%Y %X
>         AcctSQLStatement        EXEC sp_acctinsert '%{Acct-S
> ession-Id}','%{Acct-Status-Type}','%{User-Name}','%{TimeStamp}'
>
>
> Should insert the TimeStamp as '9/11/2003 21:21:21' ???

The only time the DateFormat is used in AuthBy SQL is to format AcctColumnDefs 
with integer-date types.

Timestamp can be got in a number of formats usign special characters like:

%b, %o etc.

I wonder if a new special character that means 'Timestamp in standard SQL date 
format' might be useful?

Cheers.

>
> --
> 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
>
> A successful tool is used to do something undreamed of by its author.  -
> Johnson
>
>
>
> ===
> 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.

-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985                       Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, 
TTLS, PEAP etc on Unix, Windows, MacOS etc.

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