FULLYEAR
Purpose
Enables a four-digit year format (YYYY) to comply with the year 2000 format. The default is a two-digit year format (YY).
Syntax
Usage Notes
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
To enable a four-digit year format to comply with the year 2000 format, enter the following command:
.SET FULLYEAR ON
Example
The FULLYEAR command in a Teradata SQL macro appears in the following format:
ECHO '.SET FULLYEAR ON';