From: | Mark Fenbers <mark(dot)fenbers(at)noaa(dot)gov> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Fun with Dates |
Date: | 2012-10-29 22:51:16 |
Message-ID: | 508F0864.4040609@noaa.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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 | Content-Type | Size |
---|---|---|
unknown_filename | text/html | 591 bytes |
mark_fenbers.vcf | text/x-vcard | 360 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | jan zimmek | 2012-10-30 11:45:19 | replace text occurrences loaded from table |
Previous Message | Thomas Kellerer | 2012-10-29 22:44:01 | Re: Fun with Dates |