DateTime Data Type

See Also

Choose the DateTime data type to store values that are either dates or times, or both. A DateTime value is stored in eight bytes — two four-byte integers.

Visual FoxPro 6.0 (and Visual FoxPro 5.0) support a strict Date and DateTime format that provides year 2000 compliance. It’s 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 Chapter 33, “Programming Improvements” in the Programmer’s Guide.

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}