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:

표 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

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.