Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

casting of a date into year + month name

user599926Feb 8 2009 — edited Feb 9 2009
Hi there,

I have a date column which gives data in the following formart 11/5/2008 12:00:00 . I want to convert this date into 2008 May , 2008 April.. etc.. so it can show corresponding values for each month of the year.

Currently i m using this sql in the data function in answers :

cast (YEAR("- time"."Date" ) as char ) || ' ' || MONTHNAME("- time"."Date" )


But this is only giving 2008, 2009 and not 2008 May, 2008 April. Can some one tell me what is wrong with this formula and what will be the correct one to get the date in the format i want.

Thanks

Edited by: user599926 on Feb 8, 2009 11:12 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 9 2009
Added on Feb 8 2009
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
6 comments
467 views