RE: time format

[Raymond Chen]

Rodrigo,   I think I found the problem, in the example setup file sql.conf.   You have use the variable %S which is the system timestamp in sql format when the insert command is perform.   That works when you writes both start and stop accounting records.  In my setup, I only use the stop record because that too have both h323-connnect-time and h323-disconnect-time, and that saves some unnecessary space used.   So when I do an insert I need the both variables to identify connection and disconnection time those are %{h323-connect-time} and %{h323-disconnect-time} respectively.   And those two time format are in UTC.  That’s why I have trouble doing it.   Is there a way around this, or am I just took the wrong way?   Regards   Raymond     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rodrigo Gonzalez Sent: Thursday, August 15, 2002 2:15 AM To: [EMAIL PROTECTED] Subject: Re: time format   Use AcctStartTime NOT h323-setup-time ----- Original Message ----- From: Raymond Chen To: [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 3:10 PM Subject: time format   Dear list,   Trying to setup the radius to write CDR straight to MySQL database.  But the time from NAS as “h323-setup-time=02:05:44.512 CN Thu Aug 15 2002”   and in the MySQL database script, the time is define as “0000-00-00 00:00:00”.  So when radius trys to insert to database, it returns an error say the format is incompatible.  Any solution to this.   Best Regards   Raymond