...
Example - Other date formatting variations
...
Numeric date, year first
| Source | Transform | Results | ||
|---|---|---|---|---|
2/15/16 13:26:58.123 3/12/99 2:45:21.456 11/21/11 23:02:18.000 |
| 2016-02-15 1999-03-12 2011-11-21 |
Numeric date, American style
| Source | Transform | Results | ||
|---|---|---|---|---|
2/15/16 13:26:58.123 3/12/99 2:45:21.456 11/21/11 23:02:18.000 |
| 2/15/16 3/12/99 11/21/11 |
Full written date
| Source | Transform | Results | ||
|---|---|---|---|---|
2/15/16 13:26:58.123 3/12/99 2:45:21.456 11/21/11 23:02:18.000 |
| February 15, 2016 March 12, 1999 November 21, 2011 |
Abbreviated date,
...
including abbreviated day of week
| Source | Transform | Results | ||
|---|---|---|---|---|
2/15/16 13:26:58.123 3/12/99 2:45:21.456 11/21/11 23:02:18.000 |
| Mon Feb 15, 2016 Fri Mar 12, 1999 Mon Nov 21, 2011 |
Full 24-hour time
| Source | Transform | Results | ||
|---|---|---|---|---|
2/15/16 13:26:58.123 3/12/99 2:45:21.456 11/21/11 23:02:18.000 |
| 13:26:58.123 2:45:21.456 23:02:18.000 |
Twelve-hour time with AM/PM indicator
| Source | Transform | Results | ||||
|---|---|---|---|---|---|---|
2/15/16 13:26:58.123 3/12/99 2:45:21.456 11/21/11 23:02:18.000 |
| 1:26:58 PM 2:45:21 AM 11:02:18 PM |
For more information on supported date formats, see Datetime Data Type.
...
