RE: date question

2004-10-12 Thread Carter Thompson
Lori, I'm not that familar with Postgresql, however you should check out the online documentation on SQL Functions and roll your own. Here's the link to the page. http://www.postgresql.org/docs/aw_pgsql_book/node164.html Several of the examples appear to be close to what I think you're

RE: date question

2004-10-12 Thread Charles K. Clarkson
Lori [EMAIL PROTECTED] wrote: : This is a postgresql question , slam me if you must, but : this is the only list where I get a fast response and I : know many of you use postgresql : : I have a int field called when_month and I want to use : it to get the full month name something like : :

Re: date question

2004-10-12 Thread Lori
Charles K. Clarkson wrote: Lori [EMAIL PROTECTED] wrote: : This is a postgresql question , slam me if you must, but : this is the only list where I get a fast response and I : know many of you use postgresql : : I have a int field called when_month and I want to use : it to get the full

RE: Date question

2002-05-22 Thread Zeno Lee
It depends on what you mean by following month. How do you define the following month after May 31? Is it June 30? How do you define the following month after June 30? Is it July 30? or is it July 31? February 28 - March 28? or March 31? Do you mean last number of the month, exactly 30 days

RE: Date question

2002-05-22 Thread Capacio, Paula J
I use Date::Calc; although there are lots of Date modules available. paula -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Stephen J Martin Sent: Wednesday, May 22, 2002 7:54 AM To: [EMAIL PROTECTED] Cc: Carl Jolley Subject: Re: Date question