date format

[PatelRam]

Hi,

SQL : Select MAX( business_start ) AS business_start
from calendar
output : 2004-09-01

I need date in 'Sep 01,2004' format in db2. How do I modify above sql to get me this result

Thanks in advance.

 

[PruSQLer]

Here's one way to do it. I'm sure there are others.

select rtrim(char(monthname(max(start_dt)))) || ' ' || rtrim(char(day(max(start_dt)))) || ', ' || char(year(max(start_dt)))
From Calendar