(RADIATOR) Using AcctSQLStatement with integer-date format

[Hugh Irvine]

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.