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

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

OracleLoaderColumn Class
OracleLoaderColumn Members

Send Feedback