convert number to Date

[RP]

Hi all,

I have a question, pl any one can help me. My date field is oracle database ie. number(30122007) and now I want to convert to date (YYYY-Mon) in reportstudio, pl can any one tell me how to convert number to date.

Thanks
RP

[MDXpressor]

Use the Oracle to_date function.

to_date([Date],'YYYY-MMM-DD')

The string 'YYYY-MMM-DD' can be arranged to match the output you are seeking. 

At times I have had to convert to a char first (to_date(to_char([Date]), 'YYYY-MMM-DD')

[raja.chanda]

Hi all,

I have a question, pl any one can help me. My date field is oracle database ie. number(30122007) and now I want to convert to date (YYYY-Mon) in reportstudio, pl can any one tell me how to convert number to date.

Thanks
RP

to_char(to_date(to_char([date]),'DDMMYYYY'),'YYYY-Mon')
or
to_char(to_date([date],'DDMMYYYY'),'YYYY-Mon')