Date, Time, and Timestamp - OLE DB Provider for Teradata

OLE DB Provider for Teradata User Guide

Product
OLE DB Provider for Teradata
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2498
Product Category
Teradata Tools and Utilities

Date, Time, and Timestamp

OLE DB Provider for Teradata uses the ANSI representation of the Date, Time, and Timestamp. Therefore, if a consumer submits the following Data Definition Language (DDL) statement:

CREATE TABLE Teradata1.DateTime_Test (
   Ts TIMESTAMP,
   Ti TIME,
   Dt DATE
PRIMARY INDEX (Ts));

to Teradata Database through OLE DB Provider for Teradata, the table has the following definitions in Teradata Database:

CREATE SET TABLE Teradata1.DateTime_Test ,NO FALLBACK ,
   NO BEFORE JOURNAL,
   NO AFTER JOURNAL
  (
   Ts TIMESTAMP(6),
   Ti TIME(6),
   Dt DATE FORMAT 'YYYY-MM-DD')
PRIMARY INDEX ( Ts ));