Tuesday 14 August 2012

How to convert the date field in OBIEE report to a desired date format?

CAST (expr AS type) is a conversion function in OBIEE that changes the data type of a value or a null value to another data type.This is one solution to change the datatype,but when I tried with this the column heading in report changed to different colour and my client didn't liked that solution.So I tried another solution.Follow the below steps and screenshots.

1.Go to Column Properties tab

Select column properties tab
2.Select Data Format tab
3.Check “Override Default Data Format” box
4.Select “Date Format” field dropdown as custom/as required in your report. If you select “Date Format” field dropdown as custom then specify “Custom Date Format” field as required in report.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

ShareThis