Supported Date Formats in Connect

Connect supports the following date formats for importing and exporting data. You must choose one format for uploads and one format for downloads per account.

  • Standard_Long_NoMillis ("yyyy-MM-dd HH24:mi:ss")
  • Standard_Long_NoSeconds ("yyyy-MM-dd HH24:mi")
  • Standard_Long_AM_NoSeconds ("yyyy-MM-dd HH:mi AM")
  • Standard_Long_AM_NoMillis ("yyyy-MM-dd HH:mi:ss AM")
  • Standard_Long_NoDelimiters ("yyyyMMdd HH24:mi:ss")
  • Excel_Full_Csv ("MM/dd/yyyy HH:mi:ss AM")
  • Standard_Long_Slash ("yyyy/MM/dd HH24:mi:ss")
  • Standard_Long_Slash_NoMillis ("yyyy/MM/dd HH24:mi:ss")
  • US_Long_Slash_AM_NoSeconds ("MM/dd/yyyy HH:miAM")
  • US_Long_Slash_NoMillis ("MM/dd/RRRR HH24:mi:ss")
  • US_Long_Slash_NoSeconds ("MM/dd/yyyy HH24:mi"")
  • US_Long_AM_NoMillis ("MM-dd-yyyy HH:mi:ss AM")
  • US_Long_AM_NoSeconds ("MM-dd-yyyy HH:miAM")
  • US_Long_NoSeconds ("MM-dd-yyyy HH24:mi")
  • Oracle_Format_AM_DateTime ("dd-MON-yyyy HH:mi:ss AM")
  • Oracle_RRRR_DateTime ("dd-MON-RRRR HH24:mi:ss")
  • Oracle_RRRR_AM_NoSeconds ("dd-MON-RRRR HH:mi AM")
  • Oracle_RR_DateTime ("dd-MON-RR HH24:mi:ss")
  • Oracle_RR_AM_NoSeconds ("dd-MON-RR HH:mi AM")
  • EU_Long_Slash_NoMillis ("DD/MM/yyyy HH24:mi:ss")

Learn more