All Forums Analytics
victor4tech 4 posts Joined 05/06
17 May 2006
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?

Fred 1096 posts Joined 08/04
24 May 2006

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

victor4tech 4 posts Joined 05/06
03 Jun 2006

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

You must sign in to leave a comment.