(RADIATOR) formatted TIME_STAMP in AcctSQLStatement

[Brian Morris]

Sorry - I meant...

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

(remove the spaces / colons etc)

Cheers,  Brian.

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


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