17.05 - Example of ANSI DateTime and Interval With USING - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

The following USING request modifier expects to see an 11 character field containing a string such as '21:12:57.24'.

     USING ( TimeVal TIME(2), ... )

You could import the same value using the following USING request modifier; however, it is unclear that the data is a time value with two decimal places:

     USING ( TimeVal CHARACTER(11), ... )