(RADIATOR) Using AcctSQLStatement with integer-date format

[Vangelis Kyriakakis]

Hello Hugh,

    I'm trying to calculate %{Timestamp} - %{Acct-Session-Time} in order to
get the Connect Time from the STOP packet.

                thanks
                   Vangelis

Hugh Irvine wrote:

> Hello Vangelis -
>
> Could you explain to me what you are trying to do? In other words, what
> value are you trying to calculate?
>
> thanks
>
> Hugh
>
> On Monday, Jan 20, 2003, at 23:29 Australia/Melbourne, Vangelis
> Kyriakakis wrote:
>
> > Hi again,
> >
> > I'm trying to use something like
> >
> > AcctColumnDef CONNECTTIME,%b-0%{Acct-Session-Time},integer-date
> >
> > but it doesn't work. It gives a NULL value for the CONNECTTIME
> > attribute.
> > I have also tried AcctColumnDef
> > CONNECTTIME,%{Timestamp}-0%{Acct-Session-Time},integer-date
> >
> > If I write AcctColumnDef CONNECTTIME,Timestamp,integer-date it works,
> > but
> > ofcourse it's not what I want.
> > I want to use this attribute with Sybase Datetime type
> >
> >              Regards
> >                   Vangelis
> >
> > Hugh Irvine wrote:
> >
> >> Hello Vangelis -
> >>
> >> You should use AcctColumnDef's for what you show below.
> >>
> >> See section 6.28.14 in the Radiator 3.5 reference manual.
> >>
> >> regards
> >>
> >> Hugh
> >>
> >> On Saturday, Jan 18, 2003, at 02:55 Australia/Melbourne, Vangelis
> >> Kyriakakis wrote:
> >>
> >>> Hello,
> >>>
> >>>      I want to write the following AcctSQLStatement:
> >>>
> >>> AcctSQLStatement insert into TABLE (LOGIN_TIME, LOGOUT_TIME,.....)
> >>> values
> >>> (%{Timestamp}-%{Acct-Session-Time}Formatted using integer-date and
> >>> (%Y%m%d %H:%M) Format,%{Timestamp}Formatted using integer-date and
> >>> (%Y%m%d %H:%M) Format,.......)
> >>>
> >>>      How should I write the above SQL query? I have read the manual
> >>> but
> >>> I cannot figure out the exact format of the query.
> >>>
> >>>              Regards
> >>>                  Vangelis
> >>>
> >>> ===
> >>> 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.
> >>>
> >>>
> >>
> >> --
> >> Radiator: the most portable, flexible and configurable RADIUS server
> >> anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
> >> -
> >> Nets: internetwork inventory and management - graphical, extensible,
> >> flexible with hardware, software, platform and database independence.
> >
> > ===
> > 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.
> >
> >
>
> --
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
> -
> Nets: internetwork inventory and management - graphical, extensible,
> flexible with hardware, software, platform and database independence.
>
> ===
> 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.