To_CHAR in OBIEE
Hello All,
I have 2 tables variance_trend and monthly_variance.
Both tables have load_date column.
In variance_trend it is varchar in the format YYYYMM, in monthly_variance load_date is date data type.
I am trying to convert monthly_variance.load_date to YYYYMM.I can acheive this by going to data format and select custom format etc.
But the problem is here i am doing union between these two columns.
Its throwing me error because these 2 columns are inconsistent data types.(one is varchar another is date).
In sql i can use to_char(monthly_variance,'YYYYMM') function to acheive this.
How can i acheive this in OBIEE without creating any views in database.
Thanks in advance.