How to format the output in teradata

Analytics

How to format the output in teradata

Hi,

I am a newbie and just trying a simple thing which I am finding hard to do. I want to format the output and see the formatted result. I used to write this command in Oracle but it doesn;t work here:

column check_status format a50;

where check_status is the name of the column. Can somebody tell me what is the exact command?
2 REPLIES
Teradata Employee

Re: How to format the output in teradata

Use CAST function within your SELECT, e.g.
CAST(check_status AS CHAR(50))

Re: How to format the output in teradata

Thanks Fred...I realised it is very difficult to change the attribute characteristics in teradata....