Date Data Type

  • Article

Choose the Date data type to store dates without time values.

Visual FoxPro 5.0 and later supports a strict Date and DateTime format that provides year 2000 compliance. It is recommended that you use strict date formats for all Date and DateTime constants and expressions. For more information about strict date formats, see Year 2000 Date Support.

In both Date and DateTime data types, the following rules apply:

  • {00:00:00AM} is equivalent to {12:00:00AM}, Midnight.
  • {00:00:00PM} is equivalent to {12:00:00PM}, Noon.
  • {00:00:00} to {11:59:59} is equivalent to {12:00:00AM} to {11:59:59AM}.
  • {12:00:00} to {23:59:59} is equivalent to {12:00:00PM} to {11:59:59PM}.

See Also

CREATE TABLE - SQL Command | Date Expression Creation | Data and Field Types | Date and DateTime Operators