db2 date

[PatelRam]

Hi,

How do I write following code in db2.

select
to_char(calendar.business_start ,'Mon DD,YYYY')
AS mtd_bgn_date
from dual

Thanks,

 

[gregsimpson]

PatelRam,

what are you expecting the resultant output to look like. Incidenttaly SYSIBM.SYSDUMMY1 is a good equivalent for the Oracle DUAL table.

Cheers
Greg

 

[PatelRam]

Greg,

thanks for the reply. My question is how do I convert
date into 'Mon DD, YYYY' format.
Oracle:
to_char(calendar.business_start ,'Mon DD,YYYY')

Db2 : ??

thanks,

ram

 

[gregsimpson]

Ram,

I've got something along those lines here

select char(dayofweek(current timestamp)),' ',char(monthname(current timestamp)),' ',char(year(current timestamp)) from sysibm.sysdummy1

Cheers
Greg