dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleLoaderColumn Class / DateFormat Property
Example

In This Topic
    DateFormat Property (OracleLoaderColumn)
    In This Topic
    Gets or sets date format of the OracleLoaderColumn.
    Syntax
    '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.
    public void CreateOraLoaderColumn(OracleLoader loader)
    {
      ...
      OracleLoaderColumn column = new OracleLoaderColumn("hiredate", OracleDbType.Date);
      column.DateFormat = "DD-MON-YYYY";
      ...
    }
    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

    See Also