[EMAIL PROTECTED] wrote, On 12/7/2003 5:16 PM:
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?
a simple way: create function month_begin() returns date as ' SELECT to_date(current_date,'YYYY-MM'); ' language sql STABLE;
... where date < month_begin() ....
C.
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
