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

"sqllist" <sqllist@coralindia.com> 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