Showing posts with label obiee 11g timestamp. Show all posts
Showing posts with label obiee 11g timestamp. 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’.