Date/Time (MDY) Extended

Standardization Definition

Date/Time (MDY) Extended
Description

The Date/Time (MDY) Extended standardization definition standardizes dates that have format MDY HH:MM:SS. The output is a 4-digit year followed by a zero-padded two-digit month, followed by a zero-padded two-digit day, followed by a zero-padded two-digit hour, followed by zero-padded two-digit minutes, followed by zero-padded two-digit seconds. The day, month, and year are separated by dashes and the time elements are separated by colons. The date and the time are separated by a "T".

Examples Input Output
04/07/02 2002-04-07
Oct 15 1970 1970-10-15
May 11, 2000 10:12:45 2000-05-11T10:12:45
Remarks The output of this definition is the same as Date/Time (DMY) Extended and Date/Time (YMD) Extended.

If the input year is a two-digit value, it is assumed to be within the hundred year span with 2049 as the end of the span. For example, a year of 49 will be 2049, but a year of 50 will be 1950.