Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (Postfix) with ESMTP id 768A7474E49 for ; Wed, 3 Apr 2002 16:57:45 -0500 (EST) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.5.2) with HTTP id 846741; Wed, 03 Apr 2002 13:57:44 -0800 From: "Josh Berkus" Subject: Re: date manipulation To: "Travis Hoyt" , X-Mailer: CommuniGate Pro Web Mailer v.3.5.2 Date: Wed, 03 Apr 2002 13:57:44 -0800 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200204/43 X-Sequence-Number: 7308 Travis, > Curious to know if there's an easy way to do what I'm trying to do. > As of > yet I haven't been able to find any documentation or examples that > help. > I basically want to be able to figure how how many 1st's and 15th's > there > are between date X and Y. Is there a simple solution? Please see the Time/Date/Interval FAQ: http://techdocs.postgresql.org/techdocs/faqdatesintervals.php and the documentation: http://www.postgresql.org/idocs/index.php?datatype-datetime.html Finally, Joe Celko's book "SQL For Smarties" has a question and solution very similar to what you ask above. -Josh Berkus