<div>Hi,</div><div> </div><div> I presume you are making SOAP or XML-RPC call and displaying results returned on that query. The cdr start-time is always returned in unix timestamp format. All that is needed is to convert the timestamp to Date-Time format. I do not know Perl or VB but you can find many examples of timestamp to DateTime conversion in searches...like below:</div>
<div> </div><div><a href="http://www.digitalcoding.com/Code-Snippets/VB/Visual-Basic-Code-Snippet-Convert-Unix-timestamp.html">http://www.digitalcoding.com/Code-Snippets/VB/Visual-Basic-Code-Snippet-Convert-Unix-timestamp.html</a><br>
<a href="http://www.colincochrane.com/post/2008/03/07/converting-a-unix-timestamp-to-system-datetime.aspx">http://www.colincochrane.com/post/2008/03/07/converting-a-unix-timestamp-to-system-datetime.aspx</a></div><div><br>
Skyler</div><div> </div><div class="gmail_quote">On Tue, Aug 7, 2012 at 12:03 AM, Michael Molina <span dir="ltr"><<a href="mailto:saudadez@hotmail.com" target="_blank">saudadez@hotmail.com</a>></span> wrote:<br><blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote">
<div><div dir="ltr">
I have a front end written in bisual basic that was perfect before the conversion. I thank you for your prompt response it would be nice to be able to convert this that way.<br>
Like a nice calendar to select start and end dates you know. I know nothing about Perl myself so . Perhaps if sometihing comes to mind you will be kind to let me know.<span class="HOEnZb"><font color="#888888"><br>
Michael<br></font></span><div class="hm HOEnZb"> <br>
</div><div><div class="hm HOEnZb">
<div></div>
<hr>
Date: Mon, 6 Aug 2012 23:36:41 -0700<br>Subject: Re: [Spce-user] Start time<br>From: <a href="mailto:skchopperguy@gmail.com" target="_blank">skchopperguy@gmail.com</a><br>To: <a href="mailto:saudadez@hotmail.com" target="_blank">saudadez@hotmail.com</a><br>
CC: <a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a></div><div><div class="h5"><br><br>
<div>Hi,</div>
<div> </div>
<div> The cdr call start time date is unix timestamp format. Usually, when you see the conversion in a web page such as CSC or wwwadmin this timestamp is converted by the Perl programming of the page. I don't know Perl but in PHP I use this to display call start time from cdr exposed via SOAP.</div>
<div> </div>
<div><?php echo date('Y-m-d H:i:s', $result->$array[start_time]) ?><br></div>
<div> Hope that helps.</div>
<div><br>Skyler</div>
<div> </div>
<div>On Mon, Aug 6, 2012 at 11:13 PM, Michael Molina <span dir="ltr"><<a href="mailto:saudadez@hotmail.com" target="_blank">saudadez@hotmail.com</a>></span> wrote:<br>
<blockquote style="padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid">
<div>
<div dir="ltr">Hello again and hopefuly the last question at least for a while.<br>The new format for the start time of a call (cdr table). (1343527132.82 as an example) I have tried to make sense of it to no avail.<br>Say you want to ODBC to the MySql server (cdr table in particular) hoy can you convert this number into someting like a normal date like it<br>
was on the other format?. The rate date is fine is just this one that I can't understand. My apologies for that.<br>Again thanks. Michael Molina<br></div></div><br>_______________________________________________<br>Spce-user mailing list<br>
<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br><a href="http://lists.sipwise.com/listinfo/spce-user" target="_blank">http://lists.sipwise.com/listinfo/spce-user</a><br><br>
</blockquote></div><br></div></div></div> </div></div>
</blockquote></div><br>