SET SESSION DATEFORM Syntax Elements - Advanced SQL Engine - Teradata Database
SQL Data Definition Language Syntax and Examples
- Product
- Advanced SQL Engine
- Teradata Database
- Release Number
- 17.10
- Published
- July 2021
- ft:locale
- en-US
- ft:lastEdition
- 2021-07-27
- dita:mapPath
- spp1591731285373.ditamap
- dita:ditavalPath
- spp1591731285373.ditaval
- dita:id
- B035-1144
- lifecycle
- previous
- Product Category
- Teradata Vantage™
- ANSIDATE
- A DATE format of CHARACTER(10) for the session, formatted as ‘YYYY-MM-DD’ for importing and exporting DATE values.
- INTEGERDATE
- Encoded integers for importing and exporting DATE values.
- When the session DATEFORM is INTEGERDATE, the default DATE format in field mode is 'YY/MM/DD' for date columns created and date constants in character form.
- You can use the tdlocaledef utility to change the 'YY/MM/DD' default DATE format. For details, see Teradata Vantage™ - Database Utilities, B035-1102.