Table of Contents
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.
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';