| 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: | Whole Thread | Raw Message | 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 |