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.
