Re: v2.09 TimeStamp MySQL correction of my prev posting

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

 



Better still would have been:-

CONCAT(
MID('%{connect-time}',8,4),
LPAD(FIELD(MID('%{connect-time}',1,3),
'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'),2,'
0'),
MID('%{connect-time}',5,2),
REPLACE(MID(RIGHT('%{connect-time}',12),1,8),':','')
)

That would give us:-
20050614015653





-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________________

Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users
Homepage: http://www.gnugk.org/

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

  Powered by Linux