DateFormat Property (OracleLoaderColumn)

In This Topic

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

Reference

OracleLoaderColumn Class
OracleLoaderColumn Members

Send Feedback