The following applies when a connection is established with a Teradata .NET data source:
- Teradata.NET always uses ANSI date mode.
- All date literals must be entered in YYYY-MM-DD format.
- Timestamp With Time Zone columns only sort correctly if you specify a date format of YYYY-MM-DD.
- A WITH (summary) clause in a Select statement causes the data return to fail.