CDR Time

Unanswered Question
Mar 22nd, 2010

I asked a question before aobut pulling CDR's from the Command Line after using SSH to connect to the Publisher. I got all that and am able to pull what I wanted with one exception. Time.

Is there a way like before in SQL to get the time to convert and then pull from a specific date range? Like say I want only calls from today between 3 and 4 PM.

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
bkbristlin Mon, 03/22/2010 - 13:54

I might not have been spcific enough. I am looking to put the time range in my query from the command line.

htluo Mon, 03/22/2010 - 13:58

You said "I got all that and am able to pull what I wanted with one exception.  Time.".

So I'm assuming you know all the SQL syntax but just having difficulty on converting the time to Unix format.  If that's the case, the post above gives you both online and offline tools to do the conversion.

For exmaple, 3/22/2010, 3:00PM = 1269270000.  3/22/2010, 4:00PM = 1269273600.

SQL command would be:

run sql select * from car:tbl_billing_data where datetimeconnect >= 1269270000 AND datetimeconnect < 1269273600

Michael

http://htluo.blogspot.com

Actions

This Discussion

Related Content