Date and Time
To convert data and time formats to a string, use the formats listed in Date and Time Formats.
| Value | Template Description | Example | |
|---|---|---|---|
| 1 | MM*DD*[YY]YY | 09/05/94 | (September 5, 1994) |
| 2 | DD*MM*[YY]YY | 05-09-94 | (September 5, 1994) |
| 3 | ddd*[YY]YY | 248,1994 | (September 5, 1994) |
| 4 | DD*mmm[mmmmmm]*[YY]YY | 05/Sep/94 | (September 5, 1994) |
| 5 | [YY]YY*mmm*DD | 1994-Sep-05 | (September 5, 1994) |
| -1 | HH*Mn*SS[.SSS] | 13:30:35.25 | (1:30pm) |
| -2 | HHMn | 1330 | (1:30pm) |
| The * represents a delimiter separating different fields. Also valid are slash (/), colon (:), hyphen(-), and comma (,). | |||