Records in the Now Platform store date and time values in several different types of fields. These values are stored as integer numbers, in milliseconds, and appear in the appropriate date or date/time format.

Date and Date/Time field types

The Now Platform stores date and date/time information in records using the following field types:
Table 1. Date and time field types
Field typeDictionary XML typeMySQL DB type
Date glide_date DATE
Date/Time glide_date_time DATETIME
Time glide_time DATETIME
Duration glide_duration DATETIME
Due date due_date DATETIME

For the full listing of field types, see Introduction to Fields.