BTEQ - FULLYEAR - Setting year in YYYY format in Teradata

To enable a four-digit year format to comply with the year 2000 format, enter the FULLYEAR command as follows:
.SET FULLYEAR ON;


Example:
.LOGON localtd/dbc, tdpass;
.SET FULLYEAR ON;
SELECT * FROM tbl_emp;
.LOGOFF;


FULLYEAR will affect only the titles, headings and footings.
It won't affect the outcome of SQL statements.