date question

[Lori]

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

_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs