10.9.1 AsDisplayString
AsDisplayString returns the supplied date formatted using one of the available supplied date formats or a custom format.
Input Parameters
Supplied fixed formats and the resulting display string are listed below. Examples use a datetime of 2004-12-31 12:34:56.
The month is multilingual.
| Format | Display String |
|
CCYYDDMMHHMMSS |
20043112123456 |
|
CCYYMMDDHHMMSS |
20041231123456 |
|
HHMMSSbSysFmt6 |
123456 311204 |
|
HHMMSSbSysFmt8 |
123456 31122004 |
|
HHMMSSDDMMCCYY |
12345631122004 |
|
HHMMSSDDMMYY |
123456311204 |
|
LOCALIZED_SQL |
2004-12-31 22:34:56.000000000 |
|
LOCALIZED_TZ |
2004-12-31T22:34:56.000000000+10:00 |
|
SQL |
2004-12-31 12:34:56.000000000 |
|
SysFmt6bHHMMSS |
311204 123456 |
|
SysFmt8bHHMMSS |
31122004 123456 |
|
TZ |
2004-12-31T12:34:56.000000000Z |