DateFormat Property (OracleLoaderColumn)

On this page

Gets or sets date format of the OracleLoaderColumn.

Syntax

Visual Basic
C#


'Declaration Public Property DateFormat As String


public string DateFormat {get; set;}

Property Value

The date format into which loaded data will be converted.

Remarks

Set DateFormat property to specify conversion mask for the column. OracleLoader uses DateFormat to convert string representation of date to it internal representation. If not set, the date format defaults to the date conversion mask set in the direct path context.

Format string must use Oracle datetime format model. For example, format string 'DD-MON-RR' will correspond to '27-OCT-89' date string representation.

Example

The following example creates an OracleLoaderColumn and sets DateFormat property.

csharp


public void CreateOraLoaderColumn(OracleLoader loader) { ... OracleLoaderColumn column = new OracleLoaderColumn("hiredate", OracleDbType.Date); column.DateFormat = "DD-MON-YYYY"; ... }

Visual Basic


Public Sub CreateOraLoaderColumn(loader as OracleLoader) ... Dim column As OracleLoaderColumn = new OracleLoaderColumn("hiredate", OracleDbType.Date) column.DateFormat = "DD-MON-YYYY" ... End Sub 'CreateOraLoaderColumn

Public Sub CreateOraLoaderColumn(loader as OracleLoader)
  ...
  Dim column As OracleLoaderColumn = new OracleLoaderColumn("hiredate", OracleDbType.Date)
  column.DateFormat = "DD-MON-YYYY"
  ...
End Sub 'CreateOraLoaderColumn

Reference

OracleLoaderColumn Class
OracleLoaderColumn Members

Send Feedback