FULLYEAR

Basic Teradata Query Reference

brand
Teradata Tools and Utilities
prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

Purpose

This control enables users to specify whether to use a four-digit year format (YYYY) in a report's header, footer and title lines. 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 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';