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 :
: update mytable set myfield = date_part(month,'1/5/2004');
: the problem is date part returns 5 not May
:
: If I wanted to do this in a program I could easily
: do it with an array ,but cant find quick way to do in
: postgresql ?????
:
: I have looked it up on the postgresql site and on google
: but cant find a simple function that will do the trick
I think you want the "to_char" or the "to_timestamp"
function. (Read the note.)
http://www.postgresql.org/docs/7/interactive/functions2976.htm
HTH,
Charles K. Clarkson
--
Mobile Homes Specialist
254 968-8328
_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
