Teradata.NET Specific Limitations - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product
SQL Assistant
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2430
lifecycle
previous
Product Category
Teradata Tools and Utilities

Teradata.NET Specific Limitations

  • A WITH (summary) clause in a Select statement causes the data return to fail.
  • TD.NET always uses ANSI date mode. All date literals must be entered as YYYY-MM-DD.
  • Timestamp With Time Zone columns only sort correctly if you use a date format of YYYY-MM-DD.