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
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 :
:
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
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
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