---
sourceDocument: Xanadu ServiceNow AI Platform Administration
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/platform-administration

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu ServiceNow AI Platform Administration

ft:clusterId :

    - platadm

bundleId :

    - platadm

workflow :

    - Platform


---

# Date and Date/Time fields

# Date and Date/Time fields {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

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:{#r_UseDateAndTimeFields__table_fyr_mpb_3p__entry__3}

| 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 |
[Table 1. Date and time field types]

{#r_UseDateAndTimeFields__table_fyr_mpb_3p}

For the full listing of field types, see [Introduction to Fields](https://servicenow-prod.fluidtopics.net/aOpjXT2YLx3zDM2i2E_OsQ "The individual pieces of data in a record are called fields. You enter data in fields on the form or by using the list editor. Administrators can create new or modify existing fields.").
* **[Global date and time field format](https://servicenow-prod.fluidtopics.net/vG6X7u8R4Cfr~fLvnhIwIQ)**   
  You define default date and time formats globally using system properties.
* **[Configure the date picker for the list editor](https://servicenow-prod.fluidtopics.net/eF0_rke24lhA4cNDK6Aslg)**   
  A system property enables you to choose between two date picker configurations for the list editor.
* **[Default date and time fields](https://servicenow-prod.fluidtopics.net/e55uK4t0Hz38dX9~5mP8yw)**   
  Certain time fields are provided by default to store particular date and time fields.
* **[Export date and time formats](https://servicenow-prod.fluidtopics.net/xKNVsQuuDqTySxjvm209WA)**   
  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.