FULLYEAR Command | Basic Teradata Query - 17.00 - FULLYEAR - Basic Teradata Query

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K

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


FULLYEAR 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 an SQL macro appears as follows:

ECHO '.SET FULLYEAR ON';