Re: [GENERAL] Days in month query

2005-03-31 Thread Mark Fox
Greetings, Thanks Dann, Arthur, Mike, Jeffrey, and Bruno. You've given me a quick solution and a whole lot to chew on. I never would have come up with anything as creative. Thanks again, Mark > -Original Message- > From: Mark Fox [mailto:[EMAIL PROTECTED] > Sent: We

Re: [GENERAL] Days in month query

2005-03-30 Thread Mark Fox
function. It would lead you to > this: > http://www.postgresql.org/docs/8.0/static/functions-datetime.html > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Mark Fox > Sent: Wednesday, March 30, 2005 3:07 PM > To: pgsql-general@p

[GENERAL] Days in month query

2005-03-30 Thread Mark Fox
Greetings, This is more of an SQL question, but since each database server seems to use it's own syntax for handling dates... Is there a way to query for the days in a month? For example, querying for the days in January of this year? Listing the days between two dates would be useful as well.