RAMPRADEEP PAKALAPATI
Pages
Home
Oracle Database
Contact Me
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’.
Older Posts
Home
Subscribe to:
Posts (Atom)