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’.

No comments:

Post a Comment