Date-time formats supported in Control Compliance Suite for importing external data
CCS supports the following date-time formats while importing external data.
For example if the date is 6th January 2012, and the time is 05 hrs 10 minutes and 32 seconds (24 hour clock):
- yyyy/MM/ddFor example, 2012/01/06
- dd.MM.YYYYFor example, 06.01.2012
- M/d/yyyyFor example, 1/6/2012
- d-M-yyyyFor example, 6-1-2012
- dd/MM/yyyyFor example, 06/01/2012
- yyyy-MM-ddThh:mm:ssZFor example, 2012-01-06T05:10:32Z
- M/d/yyyy h:mm:ss ttFor example, 1/6/2012 5:10:32 AM
- yyyy-MM-dd tt h:mm:ssFor example, 2012-01-06 AM 5:10:32
- yyyy-MM-dd HH:mm:ssFor example, 2012-01-06 05:10:32
- yyyy-MM-dd HH:mm:ss.fffFor example, 2012-01-06 05:10:32.600
- yyyy/MM/dd hh:mm:ss ttFor example, 2012/01/06 05:10:32 AM
- yyyy/M/d HH:mm:ssFor example, 2012/1/6 05:10:32
- yyyy-M-d H:mm:ssFor example, 2012-1-6 5:10:32
- d-M-yyyy H:mm:ssFor example, 6-1-2012 5:10:32
- dd/MM/yyyy hh:mm:ss ttFor example, 06/01/2012 05:10:32 AM
- dd/MM/yyyy HH:mm:ssFor example, 06/01/2012 05:10:32
- dd/MM/yyyy h:mm:ss ttFor example, 06/01/2012 5:10:32 AM
- dd.MM.yyyy H:mm:ssFor example, 06.01.2012 5:10:32
- d/MM/yyyy h:mm:ss ttFor example, 6/01/2012 5:10:32 AM
- d/MM/yyyy H:mm:ssFor example, 6/01/2012 5:10:32
- d/M/yyyy tt h:mm:ssFor example, 6/1/2012 AM 5:10:32
- dd-MMM-yyyyFor example, 06-Jan-2012
- dd-MMM-yyyy hh:mm:ss ttFor example, 06-Jan-2012 05:10:32 AM
- M/d/yyyy hh:mm:ss ttFor example, 1/6/2012 05:10:32 AM