| From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
|---|---|
| To: | "Travis Hoyt" <thoyt(at)npc(dot)net>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: date manipulation |
| Date: | 2002-04-03 21:57:44 |
| Message-ID: | web-846741@davinci.ethosmedia.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bernd von den Brincken | 2002-04-04 00:28:18 | Rvsd. / Re: Named column in a Function fails at ORDER BY (PgSQL 7.1) |
| Previous Message | Tom Lane | 2002-04-03 21:46:51 | Re: Named column in a Function fails at ORDER BY (PgSQL 7.1) |