16.20 - When Connected to a Teradata .NET Data Source - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty
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.