FULLYEAR - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-06-28
dita:mapPath
wmy1488824663431.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

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 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';