Skip site navigation (1) Skip section navigation (2)

Re: date range query help

From: novice <user(dot)postgresql(at)gmail(dot)com>
To: brian <brian(at)zijn-digital(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: date range query help
Date: 2008-11-20 03:43:00
Message-ID: ddcb1c340811191943t30bffd91i3996dec58b0f705f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novicepgsql-sql
2008/11/20 brian <brian(at)zijn-digital(dot)com>:
> novice wrote:
>>
>> 2008/11/20 Adam Rich <adam(dot)r(at)sbcglobal(dot)net>:
>>>
>>> select call.call_id,
>>>  call.datetime,
>>>  mobile_custodian.user_id,
>>>  call.mobile_no
>>>  call.charge
>>> from call, mobile_custodian
>>> where call.mobile_no = mobile_custodian.mobile_no
>>> and call.datetime between mobile_custodian.issue_date
>>>       and mobile_custodian.return_date
>>
>> sorry I get nothing :(
>>
>
> How about:
>
> SELECT call.call_id,
> call.datetime,
> mobile_custodian.user_id,
> call.mobile_no,
> call.charge
> FROM call
> LEFT JOIN mobile_custodian
> ON call.mobile_no = mobile_custodian.mobile_no
> AND call.datetime
>  BETWEEN
>  mobile_custodian.issue_date
>  AND
>  mobile_custodian.return_date;
>

this gave me nothing on the user_id field  :(

 call_id |      datetime       | user_id |  mobile_no  | charge
---------+---------------------+---------+-------------+--------
       1 | 2007-10-12 10:00:00 |         | 09455225998 |    4.5
       2 | 2007-10-16 13:27:00 |         | 09455225998 |    5.2

In response to

Responses

pgsql-novice by date

Next:From: Rodrigo E. De León PlicetDate: 2008-11-20 04:17:18
Subject: Re: [SQL] date range query help
Previous:From: brianDate: 2008-11-20 03:28:03
Subject: Re: date range query help

pgsql-general by date

Next:From: Bruce MomjianDate: 2008-11-20 03:58:40
Subject: Re: [GENERAL] db_user_namespace, md5 and changing passwords
Previous:From: brianDate: 2008-11-20 03:28:03
Subject: Re: date range query help

pgsql-sql by date

Next:From: Rodrigo E. De León PlicetDate: 2008-11-20 04:17:18
Subject: Re: [SQL] date range query help
Previous:From: brianDate: 2008-11-20 03:28:03
Subject: Re: date range query help

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group