What is char(7) in teradata sql in date format?

@scotty_walker 

In Teradata SQL, char(7) is a data type that represents a character string with a fixed length of 7 characters. It is typically used to store values such as dates in the format 'YYYYMM' (e.g. '202201' for January 2022). To convert a char(7) string to a date format, you can use the following syntax:

1

SELECT CAST(SUBSTRING('202201', 1, 4) || '-' || SUBSTRING('202201', 5, 2) || '-01' AS DATE FORMAT 'YYYY-MM-DD');

This will convert the char(7) string '202201' to a date format '2022-01-01'.