var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Timestamp to Varchar data conversion
I am new to DB2. I have one column with datatype as timestamp in DB2.
How can i convert datatype timestamp to varchar in select statement
I have googled it and tried 2-3 methods to convert it into varchar but not succeeded.
Waiting for your reply.
Have you tried studing the documentation on-line for your version of db2 and platform?
There's more than one way...one way is:
TO_CHAR - IBM DB2 9.7 for Linux, UNIX, and Windows
Have you tried:
char(your_timestamp) or varchar(your_timestamp)
If you want formatted output, try this: