[Spce-user] Start time

[Skyler]

Hi,

 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:

http://www.digitalcoding.com/Code-Snippets/VB/Visual-Basic-Code-Snippet-Convert-Unix-timestamp.html
http://www.colincochrane.com/post/2008/03/07/converting-a-unix-timestamp-to-system-datetime.aspx

Skyler

On Tue, Aug 7, 2012 at 12:03 AM, Michael Molina <saudadez at hotmail.com>wrote:

>  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.
> 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.
> Michael
>
>  ------------------------------
> Date: Mon, 6 Aug 2012 23:36:41 -0700
> Subject: Re: [Spce-user] Start time
> From: skchopperguy at gmail.com
> To: saudadez at hotmail.com
> CC: spce-user at lists.sipwise.com
>
>
> Hi,
>
>  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.
>
> <?php echo date('Y-m-d H:i:s', $result->$array[start_time]) ?>
>  Hope that helps.
>
> Skyler
>
> On Mon, Aug 6, 2012 at 11:13 PM, Michael Molina <saudadez at hotmail.com>wrote:
>
>  Hello again and hopefuly the last question at least for a while.
> 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.
> 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
> was on the other format?. The rate date is fine is just this one that I
> can't understand. My apologies for that.
> Again thanks. Michael Molina
>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/listinfo/spce-user
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20120807/0681227d/attachment-0001.html>