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 mo

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

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 On

Re: Re: Date question

2002-05-22 Thread Mark Bergeron
ltime(time); my $year = $year + 1900; then I just called it like this: $days[$wday], $months[$mon] $mday, $year Mark Bergeron -Original Message- From: "$Bill Luebkert"<[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Date: Tue May 21 15:25:06 PDT 2002 Subj

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 da