Re: Help me plz

Hello,

Thanks for update.

v2=# select id,name,create_date from res_partner where supplier =False and
customer=True and create_date::date <='20116-06-30' order by id desc limit 2
;
id | name | create_date
----------+----------------+----------------------------
13845945 | Faryal Ahmed | 2017-11-09 13:47:28.063494
13845944 | Ahmad Alghamdi | 2017-11-09 13:47:22.831375
(2 rows)

Please look above query.

Thanks,

Regards,
-----------------------------------------------------------------------------
----------------------------------------------
<https://pbs.twimg.com/profile_images/593124869216145408/xR_yzknH.jpg>
Dhrupesh Kotadiya
Sr. Odoo Developer

<https://www.linkedin.com/in/dhrupesh-kotadiya-99a20a61>

*Cell*: +91-97270 50349

Skype: dhrupesh.kotadiya
Twitter : KDhrupesh

-----------------------------------------------------------------------------
-----------------------------------------------

On Thu, Nov 9, 2017 at 7:11 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
wrote:

> Hi
>
> 2017-11-09 15:13 GMT+01:00 Kotadiya Dhrupesh <kotadiyadhrupesh(at)gmail(dot)com>:
>
>> Hello,
>>
>> I have got following output when run query in postgress.
>>
>> v2=# select id,name,create_date from res_partner where supplier =False
>> and customer=True order by id desc limit 2
>> ;
>> id | name | create_date
>> ----------+---------------+----------------------------
>> 13845976 | Ruth Acuna | 2017-11-09 13:48:38.755767
>> 13845975 | Jenny ramirez | 2017-11-09 13:48:38.755767
>> (2 rows)
>>
>>
>>
> It is not a bug. Please, use mailing list pgsql-general instead.
>
> What is wrong there? Looks ok
>
> Regards
>
> Pavel
>
>
>
>
>> Please help me
>>
>> Regards,
>> ------------------------------------------------------------
>> ---------------------------------------------------------------
>> <https://pbs.twimg.com/profile_images/593124869216145408/xR_yzknH.jpg>
>> Dhrupesh Kotadiya
>> Sr. Odoo Developer
>>
>>
>> <https://www.linkedin.com/in/dhrupesh-kotadiya-99a20a61>
>>
>> *Cell*: +91-97270 50349 <+91%2097270%2050349>
>>
>> Skype: dhrupesh.kotadiya
>> Twitter : KDhrupesh
>>
>> ------------------------------------------------------------
>> ----------------------------------------------------------------
>>
>
>