How to get date like this Sept 15th 2011 in oracle query result instead of 15sep2011_00:00:00?
I am executing a query

    select level as VERSION,
    name as DESCRIPTION,code as CODE,created as RELEASEDATE
    ,SUBSTR(name, INSTR(name, '.',-1)+1) as TYPE
    from mytable
    where code = 'HX56UO'

which gives result like 

    Type 	Version 	Description		  Release Date 	 
    .exe 	3.0.2 	MPC560xB MCAL Autosar 3.x 	 15sep2011_00:00:00

I need release date like this Sept 15th 2011 and i need to set this result value in a bean set method. 

    public void setLastDate(java.util.Calendar newLastPubDate) {
    
    	lastDate = newLastDate;
    
    }


what type casting i need to do in setting the above value from result set
since the set method is of calender.
i tried like setting the value like this

    if (rs.getDate("RELEASEDATE") != null ) {
    Bean.setLastPubDate(rs.getdate"RELEASEDATE"));
    }

But it is not date format,its of calender how to set the value.
Please help me solving this.
Thanks.
How to get date like this Sept 15th 2011 in oracle query result instead of 15sep2011_00:00:00?
===

I am executing a query

    select level as VERSION,
    name as DESCRIPTION,code as CODE,created as RELEASEDATE
    ,SUBSTR(name, INSTR(name, '.',-1)+1) as TYPE
    from mytable
    where code = 'HX56UO'

which gives result like 

    Type 	Version 	Description		  Release Date 	 
    .exe 	3.0.2 	MPC560xB MCAL Autosar 3.x 	 15sep2011_00:00:00

I need release date like this Sept 15th 2011 and i need to set this result value in a bean set method. 

    public void setLastDate(java.util.Calendar newLastPubDate) {
    
    	lastDate = newLastDate;
    
    }


what type casting i need to do in setting the above value from result set
since the set method is of calender.
i tried like setting the value like this

    if (rs.getDate("RELEASEDATE") != null ) {
    Bean.setLastPubDate(rs.getdate"RELEASEDATE"));
    }

But it is not date format,its of calender how to set the value.
Please help me solving this.
Thanks.