Showing posts with label covert timestamp to date obiee 11g. Show all posts
Showing posts with label covert timestamp to date obiee 11g. Show all posts

Tuesday, November 29, 2011

Conversion of Timestamp to date and vice-versa in Answers.


Conversion of Timestamp to date and vice-versa in Answers.
In Criteria ..on the column click on EDIT FORMULA
Change the formula as shown…
Formula : CAST (CAST (expression as CHAR (20)) as TIMESTAMP)
Click on ‘OK’.