Hello Robert, OK, to make things easy, we have now added a new special character. %A is replaced by the Timestamp in standard SQL date format eg: Sep 12, 2003 15:48.
(Also %B is replaced by the current time in standard SQL date format eg: Sep 12, 2003 15:48.) New patch for Util.pm is available in the usual place. On Fri, 12 Sep 2003 02:56 pm, Robert Blayzor wrote: > > > So lets say I'm using MSSQL... > > > > > > DateFormat %m/%d/%Y %X > > > AcctSQLStatement EXEC sp_acctinsert '%{Acct-S > > > ession-Id}','%{Acct-Status-Type}','%{User-Name}','%{TimeStamp}' > > > > > > > > > Should insert the TimeStamp as '9/11/2003 21:21:21' ??? > > > > The only time the DateFormat is used in AuthBy SQL is to > > format AcctColumnDefs > > with integer-date types. > > > > Timestamp can be got in a number of formats usign special > > characters like: > > > > %b, %o etc. > > > > I wonder if a new special character that means 'Timestamp in > > standard SQL date > > format' might be useful? > > Well that being said. How am I able to easily pass in a "TimeStamp" > field in the format I need so that my specific "AcctSQLStatement" can > insert it however I need it. (see above). Since stored procedurs use > argument lists instead of direct insert column/value pairs. > > Given above, I need to get TimeStamp into the format above to pass it in > the argument list. > > -- > Robert Blayzor, BOFH > INOC, LLC > [EMAIL PROTECTED] > > Exclusive: We're the only ones who have the documentation. -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985 Fax +61 3 9598-0955 Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, TTLS, PEAP etc on Unix, Windows, MacOS etc. === 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.