(RADIATOR) formatted TIME_STAMP in AcctSQLStatement

[Robert Blayzor]

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' ???

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