Field_Store_Time

Time portion of a datetime column.

Supported By

SQL Drivers (SQL Server, DB2 and ODBC)

Value

.. 86400

Associated Attribute

DF_FIELD_STORE_TIME (Integer)

Description

This keyword sets the time portion for a datetime type column. For more information on the datetime type, see the documentation for your server.

The integer represents the number of seconds in the day. A value of –1 indicates that the server time will be used. Any other negative value indicates that the client’s system time will be used.

The time portion will be stored upon save, every time the column is changed. Datetime columns contain a date and a time portion. The driver will report the column as being of the DF_DATE type.

In a DataFlex program, the column can be manipulated using the date logic in DataFlex. The time portion can be set using this attribute. The time portion of a datetime column cannot be read by DataFlex; this can only be done Using Embedded SQL.

For a more flexible way to manipulate the time portion of a datetime column, see DF_FIELD_TIME.

See Also

Column Keywords