Date and Date/Time fields
Records in the ServiceNow AI 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 ServiceNow AI Platform stores date and date/time information in records using the following 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 |
For the full listing of field types, see Introduction to Fields.
- Global date and time field format
You define default date and time formats globally using system properties. - Configure the date picker for the list editor
A system property enables you to choose between two date picker configurations for the list editor. - Default date and time fields
Certain time fields are provided by default to store particular date and time fields. - Export date and time formats
Because some export formats are intended for human consumption and others for database usage, various methods are used to provide date and time field information in different formats.
Parent Topic:Exploring time configuration