Sorry - I meant... formatted-date,'%Y%m%e%H%M%S'
(remove the spaces / colons etc) Cheers, Brian. ----- Original Message ----- From: "Brian Morris" <[EMAIL PROTECTED]> To: "Robert Blayzor" <[EMAIL PROTECTED]>; "tracker" <[EMAIL PROTECTED]>; "Radiator" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > To: "tracker" <[EMAIL PROTECTED]>; "Radiator" <[EMAIL PROTECTED]> > Sent: Thursday, September 11, 2003 10:09 PM > Subject: Re: (RADIATOR) formatted TIME_STAMP in AcctSQLStatement > > > > On 9/11/03 7:23 PM, "tracker" <[EMAIL PROTECTED]> 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 > > [EMAIL PROTECTED] > > 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 [EMAIL PROTECTED] > > To unsubscribe, email '[EMAIL PROTECTED]' with > > 'unsubscribe radiator' in the body of the message. > > > === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
