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. |