Switch to: V9V8V7V6V5

DateTime Field

Range of Type

This type of field can keep any datetime values.

Storage

This field always uses 4 bytes on disk per value. In fact datetime value is stored as a regular ULONG value.

Flags

  • fNullable

This field can be declared as Nullable. In this case a special bitmap is associated with this field.

  • fIndexed

This field can have flag fIndexed.

  • fUnique

This field can have flag fUnique.

Read Mode About Field Flags

API

This field type is represented at the API level by VDateTime Class.

SQL

At SQL Level you can create such field using

CREATE TABLE T1( fldDateTime DATETIME );

You can use this field in any predicate expression, e.g.

SELECT * FROM T1 WHERE fldDateTime = '2007/09/01 12:12:12';