Re: [SQL] Fun with Dates

[Mark Fenbers]

Or the other way round: anything that is equal or greater than the first of the current month: select ... from foobar where obstime >= date_trunc('month', current_date); I knew it had to be something simple!   thanks! Mark

<<attachment: mark_fenbers.vcf>>

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql