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
Are you getting this error “Installer User Interface Mode Not Supported. The installer cannot run in this UI mode. To specify the interface mode, use the -i command-line option, followed by the UI mode identifier. The value UI mode identifiers...
The below trick might come handy when you have to add a new node to a cluster but you don't have or is unsure of the security password for the publisher. This procedure has been around for ages.
1) Login into the CLI of the Publisher.