Skip to content

DF_DATABASE_DEFAULT_DEFAULT_DATETIME

Sets up the default value that will be used when a DateTime column is created.

Level

Database

Supported by

The DataFlex SQL Drivers (SQL Server, DB2, and ODBC), revision 5 and higher.

Type

String, temporary

Access

Read/Write

Values

Any valid default value for a DateTime column.

Syntax

Use cli.pkg
Get_Attribute DF_DATABASE_DEFAULT_DEFAULT_DATETIME of {driverNumber} {databaseHandle} to {StringVariable}
Set_Attribute DF_DATABASE_DEFAULT_DEFAULT_DATETIME of {driverNumber} {databaseHandle} to {StringVariable}

Driver Configuration Keyword

Default_Default_DateTime

Remarks

Sets up the default value that will be used when a DateTime column is created. Columns can be created during conversion or within a restructure operation.

Example

Procedure ShowDBAttribute Integer iDriver Handle hDatabase
    String sAttribValue
    Get_Attribute DF_DATABASE_DEFAULT_DEFAULT_DATETIME of iDriver hDatabase to sAttribValue
    Showln "Default DateTime: " sAttribValue
End_Procedure

The sample code above shows the current setting for a given database. The database handle can be obtained via the DF_DATABASE_ID attribute.