Hi,
Teradata 13.0 when using ANSI teradata mode data conversion decimal to varchar of same length getting blank as output.
sel 0 (decimal(3,0))(varchar(3))
0
--------
 
But using ansi mode conversion format getting expected value as 0.

From the TD user manual, i got this as an example of timestamp to time conversion:

SELECT CAST(cast('1997-12-31 23:59:59' as timestamp(5)) AS TIME(5) WITH TIME ZONE);

But why the time zone? how can I extract just the time with no timezone. I didn't define any timezones anywhere...

Any thoughts on this would be great