15.00 - DateForm - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

DateForm

Purpose  

Defines whether IntegerDate or ANSIDate formatting is used for a session.

Field Group

General

Valid Settings

 

Setting

Description

0 (IntegerDate)

Columns with DATE and PERIOD(DATE) type values use the format specified in the SDF file. The default format is ‘YY/MM/DD’, however the SDF file can be customized by a system administrator to change this date format.

1 (ANSIDate)

Date columns are formatted for output as 'YYYY-MM-DD'.

Default

0 (IntegerDate)

Changes Take Effect

For new sessions begun after the DBS Control Record has been written. Existing sessions are not affected.

Usage Notes  

DateForm can be overridden at the user level and at the session level (at logon or during the session).

Related Topics

 

For more information on…

See…

The SDF file

Teradata Locale Definition Utility (Tdlocaledef).

DateForm

SQL Fundamentals.