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’.
By at
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)