How to specify the beginning of the month in Postgres SQL syntax?

Поиск
Список
Период
Сортировка
От jeff@dnuk.com
Тема How to specify the beginning of the month in Postgres SQL syntax?
Дата
Msg-id t6k6tv8unr1dm7kpeb275ca0t9in2i910h@4ax.com
обсуждение исходный текст
Ответы Re: How to specify the beginning of the month in Postgres SQL syntax?  (Paul Thomas <paul@tmsl.demon.co.uk>)
Список pgsql-sql
Hello,

I need to create a view in Postgres that has a where clause of the
date < beginning of month.

i.e.:
SELECT supplier_number, Sum(amount) AS due 
FROM purchase_orders 
WHERE date < '2003-12-1' AND paid = 0 
GROUP BY supplier_number 
ORDER BY supplier_number ASC


As you can see, I've specified the 1st of December this year as the
where clause. What I want is an SQL statement that automatically
generates the first of the month. How do I do this?

Thanks.


В списке pgsql-sql по дате отправления:

Предыдущее
От: CoL
Дата:
Сообщение: Re: How to specify the beginning of the month in Postgres SQL syntax?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Fetch a single record