Re: How to query by month?

On 11/29/2016 06:08 AM, taizi wrote:
> Hi all,
> im a beginner for SQL, and  trying to use it with my daily work.
> Now i catched this question(my title of mail).
> Suppose there is a table about orders, i want to sum the total amount of
> each month.
> There was a statement of mine to november.
> select  sum(order_amount) FROM table_name WHERE order_date between
> '2016-11-01' AND '2016-11-30';
> I know it comes a result what i want, but i hope someone can tell me
> another way to use.
> After searched, i found  there is a function named date_part, but it
> doesn't work.

select sum(order_amount) from table_name where date_part('month',
order_date) = '$month';

Note that the $month will be the month number, not name. So for
November, it will = 11.

JD



> thanks for any help!
> Leopold
>
>
>
>
>


--
Command Prompt, Inc.                  http://the.postgres.company/
                         +1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
Unless otherwise stated, opinions are my own.