From: Mark Fenbers <mark.fenbers@noaa.gov>
To: pgsql-sql@postgresql.org
Subject: Re: Fun with Dates
Date: Mon, 29 Oct 2012 18:51:16 -0400
Message-ID: <508F0864.4040609@noaa.gov> (raw)
In-Reply-To: <k6n0qf$c8f$1@ger.gmane.org>
References: <508F0576.4020404@noaa.gov>
<k6n0qf$c8f$1@ger.gmane.org>
This is a multi-part message in MIME format.
--------------090700040106050301090907
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFCC" text="#000000">
<br>
<blockquote cite="mid:k6n0qf$c8f$1@ger.gmane.org" type="cite">Or the
other way round: anything that is equal or greater than the first
<br>
of the current month:
<br>
<br>
select ...
<br>
from foobar
<br>
where obstime >= date_trunc('month', current_date);
<br>
</blockquote>
I knew it had to be something simple! thanks!<br>
Mark<br>
</body>
</html>
--------------090700040106050301090907
Content-Type: text/x-vcard; charset=utf-8;
name="mark_fenbers.vcf"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="mark_fenbers.vcf"
YmVnaW46dmNhcmQNCmZuOk1hcmsgRmVuYmVycw0KbjpGZW5iZXJzO01hcmsNCm9yZzpPaGlv
IFJpdmVyIEZvcmVjYXN0IENlbnRlcjtIeWRyb21ldGVvcm9sb2dpY2FsIEFuYWx5c2lzICYg
U3VwcG9ydCBVbml0DQphZHI6MTkwMSBTb3V0aCBPSC0xMzQ7O05hdGlvbmFsIFdlYXRoZXIg
U2VydmljZTtXaWxtaW5ndG9uO09IOzQ1MTc3LTk3MDg7VVNBDQplbWFpbDtpbnRlcm5ldDpN
YXJrLkZlbmJlcnNAbm9hYS5nb3YNCnRpdGxlOlNlbmlvciBNZXRlb3JvbG9naXN0DQp0ZWw7
d29yazo5MzctMzgzLTA0MzANCnRlbDtmYXg6OTM3LTM4My0wMDMzDQp1cmw6d2VhdGhlci5n
b3Yvb2hyZmMNCnZlcnNpb246Mi4xDQplbmQ6dmNhcmQNCg0K
--------------090700040106050301090907--
Attachments:
[text/x-vcard] mark_fenbers.vcf (360B, ../508F0864.4040609@noaa.gov/2-mark_fenbers.vcf)
download | inline:
begin:vcard
fn:Mark Fenbers
n:Fenbers;Mark
org:Ohio River Forecast Center;Hydrometeorological Analysis & Support Unit
adr:1901 South OH-134;;National Weather Service;Wilmington;OH;45177-9708;USA
email;internet:Mark.Fenbers@noaa.gov
title:Senior Meteorologist
tel;work:937-383-0430
tel;fax:937-383-0033
url:weather.gov/ohrfc
version:2.1
end:vcard
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mark.fenbers@noaa.gov
Subject: Re: Fun with Dates
In-Reply-To: <508F0864.4040609@noaa.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox