TdDate Constructor(Int32)

A Date represented as an integer is converted into a TdDate.

Syntax

'Declaration
 
Public Function New( _
   ByVal value As Integer _
)

'Usage
 
Dim value As Integer
 
Dim instance As New TdDate(value)

public TdDate( 
   int value
)

public:
TdDate( 
   int value
)

Exceptions

Exception	Description
System.ArgumentOutOfRangeException	The value cannot be represented as a TdDate.

Remarks

It is not recommended that this constructor be used to create a TdDate.

The integer that can be converted to a date is the same as described in the Teradata SQL Reference: Data Types and Literals.

The date components contained in an integer will be determined by the same formula as used by the Advanced SQL Engine:

(year – 1900) * 10000 + (month * 100) + day

Therefore, the date components that are in the 1900’s will appear in the integer as

YYMMDD

Here are some examples of conversions from Int32 to TdDate:

Requirements