> On Thursday 09 September 2004 18:42, Freddy Parra wrote: > If MySQL version <= 4 supported Store Procedures one could be able to > parse out the date and convert to a DATETIME MySQL type very easily. > MySQL 5 is suppose to support SPs. > > One could also possibly look at the available date time and string > functions MySQL supports and try creating a query that would do this > for you. But this to me seems like a lot of overhead in my opinion. > > Perhaps we should have a new parameter in the [FileAcct] section > called CDRDateFormat. In here we specify the date format we would > like our CDRs to have. For example, like CDRDateFormat=yyyy-MM-dd > hhmmss or any format desired. > It might be good to support this in FileAcct too. regards Andrew ------------------------------------------------------- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 13. Go here: http://sf.net/ppc_contest.php _______________________________________________________ List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Homepage: http://www.gnugk.org/