Re: How to store h323-setup-time, h323-connect-time, h323-disconnect-time into MySQL v4.x as DATETIME type

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> 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/

[Index of Archives]     [SIP]     [Open H.323]     [Gnu Gatekeeper]     [Asterisk PBX]     [ISDN Cause Codes]     [Yosemite News]

  Powered by Linux