Hi Robert:
On Fri, Jul 10, 2015 at 6:55 PM, Robert DiFalco
wrote:
>>> I want to do a query from an application that returns all devices who's
>>> time is between 10am or 10pm for a given instant in time.
.
> Thanks John, let me revise my original query to give a CORRECT and working
> example,
On Fri, Jul 10, 2015 at 9:40 AM, John McKown
wrote:
> On Fri, Jul 10, 2015 at 11:15 AM, Robert DiFalco > wrote:
>
>> I have a table something like this:
>>
>> CREATE TABLE devices (
>> owner_idBIGINT NOT NULL,
>> utc_offset_secs INT,
>> PRIMARY KEY (uid, platform),
>> FOREIGN KEY
On Fri, Jul 10, 2015 at 11:15 AM, Robert DiFalco
wrote:
> I have a table something like this:
>
> CREATE TABLE devices (
> owner_idBIGINT NOT NULL,
> utc_offset_secs INT,
> PRIMARY KEY (uid, platform),
> FOREIGN KEY (owner_id) REFERENCES users(id) ON DELETE CASCADE
> );
>
>
> I wa
I have a table something like this:
CREATE TABLE devices (
owner_idBIGINT NOT NULL,
utc_offset_secs INT,
PRIMARY KEY (uid, platform),
FOREIGN KEY (owner_id) REFERENCES users(id) ON DELETE CASCADE
);
I want to do a query from an application that returns all devices who's
time is b