Dear all,I am using gnugk v2.0.8 release.How can I store h323-setup-time, h323-connect-time, h323-disconnect-time into MySQL v4.x as DATETIME type?MySQL do not like this format "'18:56:34.000 HKT Thu Sep 09 2004".
2004/09/09 18:56:34.356 2 RasTbl.cxx(2005) CallTable::Insert(CALL) Call No. 1, total sessions : 12004/09/09 18:56:34.357 5 gksql.cxx(338) SQLAcct Executing query: INSERT INTO offnet_cdrs (GatekeeperName, CallNumber, AcctSessionId, H323CallingId, H323CallId, H323ConfId, Q931SetupTime, CallerIP, CallerPort, CalleeIP, CalleePort, SrcInfo, DestInfo, CallingStationId, CalledStationId) VALUES ('GK1', '1', '414036db00000001', '671', '41 34 6e 8c 00 f1 18 10 83 a9 00 e0 4c eb 23 cc', '41 34 6e 8c 00 f1 18 10 83 aa 00 e0 4c eb 23 cc', '18:56:34.000 HKT Thu Sep 09 2004', '192.168.0.4','19900','192.168.0.28','1720','671:dialedDigits','16998771:dialedDigits','671', '16998771')2004/09/09 18:56:34.360 3 gkacct.cxx(884) GKACCT SQLAcct logged event 1 for call no. 12004/09/09 18:56:34.360 2 gkacct.cxx(924) GKACCT Successfully logged event 1 for call no. 1
??????????????????????骬甸殜X?矈辵紒瀗Z 壟óK!QBZ健'店楫+ 'au朕枈^(栂苲塄悍難?? @y茶?⒐,唺|?hu?嗃i?趘翔辟?壙?訋?Yhs鴿酉鑹?????????????????????蜮策违獒適鄵z??-雏(悍 ~娻{窜?撖m??嫬q玷???櫒?婘縹婎淂a璁?夌廏﹋?踚?鹈酁??
