yogi wrote:
> Hi,
> I am working on a database that has a variable with timestamp
> values. I wanted to convert the variable from timestamp to yyyy-mm-dd
> format.
db2 => VALUES SUBSTR(VARCHAR(CURRENT TIMESTAMP), 1, 10);

1
----------
2008-02-07

1 record(s) selected.

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab