Enables a four-digit year format (YYYY) to comply with the year 2000 format. The default is a two-digit year format (YY).
If the FULLYEAR command is used without specifying ON or OFF, BTEQ sets FULLYEAR to ON.
FULLYEAR only affects the date in the header, footer, and title lines. The date data returned from the SQL is not affected by the FULLYEAR command.
If the FULLYEAR command has not been used, its value is ON by default.
Example 1 – FULLYEAR
Enable a four-digit year format to comply with the year 2000 format as follows:
.SET FULLYEAR ON
Example 2 – FULLYEAR instigated by a macro
The FULLYEAR command in a Teradata SQL macro appears as follows:
ECHO '.SET FULLYEAR ON';