Dates should be entered in the following format: YYYY-MM-DD hh:mm:ss, where:
-
YYYY is the four-digit year.
-
MM is the two-digit month.
-
DD is the two-digit day.
-
hh is hours in 24-hour notation.
-
mm is minutes.
-
ss is seconds.
For example, a complete entry would be the following: 2015-05-01 17:53:00. This corresponds to 5:53 PM on May 1, 2015.
Note: Hours must be entered in 24-hour notation (e.g., 17:53:00, not 5:53:00). AM and PM should never be included. Unless otherwise noted in the applicable Mappings Document, times entered should be based on the time zone of the user who will be performing the data load.”