Date and time fields

Records can store date and time values in several different types of fields.

These values are stored in the database as integer numbers of milliseconds, and are displayed in the appropriate date or time format.

Date and time field types

The following field types are provided for storing date and time information in records.
Table 1. Date and time field types
Field type Dictionary XML type MySQL 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