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 Responsys Express instance.
- 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")