---
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


---

# Export date and time formats

# Export date and time formats {#ariaid-title1}

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

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.

## Excel

Date, Date-Time, and Time fields are all exported as their display values, and appear in a
custom format, instead of the system date format. However, duration fields, export as the value
stored in the database, which is an integer value of seconds.  
Note:  
If the date and time format is <kbd class="ph userinput">hh:mm:ss</kbd> in the glide.sys.date_format System Properties setting, and you export time values to Excel, they appear in 24-hour military time.

To display the exported values in
standard 12-hour am/pm time formats, select the <kbd class="ph userinput">1:30PM time</kbd> format in Format CellsTime in Excel.

## XML

All Date and Time fields export as the value stored in the database.

## PDF

All Date and Time fields (including Duration) export as their display value.

## CSV

All Date and Time fields export as the value stored in the database.

*[\>]: and then