Two types of date/time formats are supported, Server and Local.
-
Server format is: yyyy/mm/dd-hh:mm:ss:mmm. The Server format supports this format whether the time is specified or not. If a time is specified, then the time is adjusted using regional time settings. If no time is specified, then the string 00:00:00 (indicating midnight local time) is appended. This time string is then converted to GMT time using regional settings.
-
Local format is different because the date is entered based on the local date format specified in the Control Panel Settings. For example, May 31, 2012 could be entered as 05/31/2012 or 31/05/2012 depending on your location. The local time format is: hh:mm:ss and does not support milliseconds. If a date and time are specified, the "-" separator is used as shown in the Server format. If no time is specified, then the local date is converted to the server format and the time string 00:00:00 (indicating midnight local time) is appended. This time string is then converted to GMT time using regional settings. All conversions are done before sending the date and time to the server.