Converting Month integer to Month Label (JAN)

[dbranch]

I have set my SQL statement to group invoices by month by using the month function, i.e  month(Date). This works fine and returns the month as an integer whenused as a field. I was wondering if anyone has written an expression to convert this integer into a month label, either as the month name or the three letter abreviation? Thanks.

[slow]

try to use this in your textfield (class type String) expression:

$F{MONTH}.intValue()==1?"JAN":
    $F{MONTH}.intValue()==2?"FEB":
        $F{MONTH}.intValue()==3?"MAR":
            $F{MONTH}.intValue()==4?"APR":
                $F{MONTH}.intValue()==5?"MAY":
                    $F{MONTH}.intValue()==6?"JUN":
                        $F{MONTH}.intValue()==7?"JUL":
                            $F{MONTH}.intValue()==8?"AUG":
                                $F{MONTH}.intValue()==9?"SEP":
                                    $F{MONTH}.intValue()==10?"OCT":
                                        $F{MONTH}.intValue()==11?"NOV":"DEC";

 

______________________________
if it works... KARMA point please!    : ) 

[dbranch]

Thanks..It worked like a charm

[pacoomu]

Hello,

I think the best way to resolve this problem is to create a table with month names and numbers, and join it. Something like this:

 

SELECT table1.field1, table1.field2, months.name

FROM table1 LEFT JOIN months on months.id=month(date)

[thangalin]

(new java.text.DateFormatSymbols().getShortMonths()[$F{MONTH} - 1]).toUpperCase()

Post Edited by thangalin at 05/13/2010 05:21

[thangalin]

Helps with I18N, if that's an issue ...

Post Edited by thangalin at 05/13/2010 05:06