Skip to content

DF_FIELD_STORE_TIME

The time portion for a datetime column when creating new records.

Level

Column

Supported by

The DataFlex SQL Drivers (SQL Server, DB2, and ODBC)

Type

Integer, permanent

Access

Read / Write

Values

  • 0 ~ Maximum number of seconds in a day (60 * 60 * 24 = 86400)

Syntax

Use cli.pkg
Get_Attribute DF_FIELD_STORE_TIME of {tableNumber} {columnNumber} to {IntegerVariable}
Set_Attribute DF_FIELD_STORE_TIME of {tableNumber} {columnNumber} to {IntegerVariable}

Remarks

This attribute sets the time portion of a datetime column. The time portion will be stored upon every save operation for which the column has changed. The value represents the number of seconds in the day where:

  • A negative value less than -1 means that the client system time is used.
  • A value of -1 means that the server time is used.
  • A value between 0 and 86400 (inclusive) represents the time by the number of seconds in the day.

This attribute can be set both inside and outside a Structure_Start ... Structure_End operation. A more flexible way to manipulate the time portion of a datetime column is the DF_FIELD_TIME attribute.

We recommend using the DF_FIELD_TIME attribute instead of the DF_FIELD_STORE_TIME attribute.