"sqllist" <[EMAIL PROTECTED]> writes: > WHERE date < to_date( to_char(current_date,'yyyy-MM') || '-01','yyyy-mm-dd')
That seems like the hard way. Try this:
regression=# select date_trunc('month', now());
date_trunc
------------------------
2003-12-01 00:00:00-05
(1 row)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
