Category "teradata-sql-assistant"

split int col in Teradata

I was trying to split int column in Teradata but its showing error *** Failure 9134 Unsupported type detected. SELECT col1,strtok(col2,0 ,1) FROM table;

Teradata : Extract Date from string

There is a notation field with different number of characters. Eg Exceed Limit Fee 26-January-2020 or Account Exceed Limit Fee 05-June-2001 I want to extract