Yeah guys from http://2ndquadrant.com/ are good, especially if you have a
large dataset and your business depends heavily on it. But I assume if
their management wants to cut costs, they expect that their employees will
be able to handle completely new technology with not much prior experience
(fir
:00.00' and '2014-07-30
23:59:59.99')
AND
("payments"."created_at" BETWEEN '2014-07-07 00:00:00.00' AND
'2014-07-07 23:59:59.99')
GROUP BY 1
ORDER by 1 asc
So use the payment.created_at to for the current date and the range for the
us
Thank you for your response guys.
On Wed, Jul 30, 2014 at 9:25 PM, Chris Curvey wrote:
>
>
>
> On Wed, Jul 30, 2014 at 8:41 PM, Emir Ibrahimbegovic <
> emir.ibrahimbego...@gmail.com> wrote:
>
>> Hello all,
>>
>> I've got two queries which should
Hello all,
I've got two queries which should produce the same results but they don't
for some reason, please consider these :
SELECT date_trunc('day', payments.created_at) "day",
SUM("payments"."amount") AS sum_id FROM "payments"
INNER JOIN "users" ON "users"."id" = "payments"."user_id" WHERE
"
