EnableTdDateTime Property

Enables and disables mapping of DATE, TIME, TIME WITH ZONE, TIMESTAMP and TIMESTAMP WITH ZONE to TdDate, TdTime, TdTimeWithTimeZone, TdTimestamp and TdTimestampWithTimeZone provider specific types.

Syntax

Visual Basic
C#
C++/CLI

'Declaration
 
Public Property EnableTdDateTime As Boolean

'Usage
 
Dim instance As TdConnectionStringBuilder
Dim value As Boolean
 
instance.EnableTdDateTime = value
 
value = instance.EnableTdDateTime

public bool EnableTdDateTime {get; set;}

public:
property bool EnableTdDateTime {
   bool get();
   void set (    bool value);
}

Property Value

Defaults to true. It can be set to false to disable creation of provider specific DateTime value types for the corresponding Teradata DateTime data types.

Remarks

TdDataReader.GetProviderSpecificFieldType will always return TdDate, TdTime, TdTimeWithTimeZone, TdTimestamp or TdTimestampWithTimeZone type corresponding To the SQL data type when EnableTdDateTime is set to true. It will return DateTime, TimeSpan or DateTimeOffset String when EnableTdDateTime is set to false.

This feature has been added for backward compatibility with older applications. For example an older application, might have set Data.Common.DataAdapter.ReturnProviderSpecificTypes to true and later assumed that the resulting columns in Data.DataTable are of System.DateTime type.

Default Value: true

Requirements

Target Platforms: Windows 8.1, Windows 10, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019

Reference

TdConnectionStringBuilder Class
TdConnectionStringBuilder Members