PipelineBuffer.GetDateTime Method

Gets the DateTime value stored in the PipelineBuffer column.

Namespace:  Microsoft.SqlServer.Dts.Pipeline
Assembly:  Microsoft.SqlServer.PipelineHost (in Microsoft.SqlServer.PipelineHost.dll)

Syntax

'Declaration
Public Function GetDateTime ( _
    columnIndex As Integer _
) As DateTime
'Usage
Dim instance As PipelineBuffer
Dim columnIndex As Integer
Dim returnValue As DateTime

returnValue = instance.GetDateTime(columnIndex)

public DateTime GetDateTime(
    int columnIndex
)

public:
DateTime GetDateTime(
    int columnIndex
)

member GetDateTime : 
        columnIndex:int -> DateTime 

public function GetDateTime(
    columnIndex : int
) : DateTime

Parameters

• columnIndex
  Type: System.Int32
  The index of the column in the PipelineBuffer row.

Return Value

Type: System.DateTime
The DateTime value stored in the PipelineBuffer column.

Remarks

This method works with the following Integration Services data types:

• DT_DATE

• DT_DBTIMESTAMP

• DT_DBTIMESTAMP2

• DT_FILETIME

If the value of the column is null, the PipelineBuffer produces a ColumnIsNullException. You can check for null by calling the IsNull method.

For a complete list of Integration Services data types and the corresponding Get and Set methods of the PipelineBuffer class to use with each type, see Working with Data Types in the Data Flow.

See Also

Reference

PipelineBuffer Class

PipelineBuffer Members

Microsoft.SqlServer.Dts.Pipeline Namespace