====== 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. 

[[valentina:vcomponents:vkernel:vfield:flags | Read Mode About Field Flags]]

===== API =====

This field type is represented at the API level by [[valentina:products:adk:api:vdatetime_class:vdatetime_class]]. 

===== SQL =====

At SQL Level you can create such field using 

<code sql>
CREATE TABLE T1( fldDateTime DATETIME );
</code>

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

<code sql>
SELECT * FROM T1 WHERE fldDateTime = '2007/09/01 12:12:12';
</code>