Extended DATETIME-format strings
HCL OneDB™ ESQL/C DATETIME-format functions support extended-format strings.
The following table shows the extended-format strings
that the HCL
OneDB ESQL/C DATETIME-format
functions support.
| Format | Description | December 27, 1991 printed |
|---|---|---|
| %y %m %dc1 | Taiwanese Ming Guo date | 80 12 27 |
| %Y %m %dc1 | Taiwanese Ming Guo date | 0080 12 27 |
| %y %m %dj1 | Japanese era with abbreviated era symbols | H03 12 27 |
| %Y %m %dj1 | Japanese era with abbreviated era symbols | H0003 12 27 |
| %y %m %dj2 | Japanese era with full era symbols | A1A2B1B203 12 27 |
| %Y %m %dj2 | Japanese era with full era symbols | A1A2B1B20003 12 27 |
In addition to the formats in the preceding table, these HCL OneDB ESQL/C DATETIME-format functions support the GLS date and time specifiers. For a list of these specifiers, see GL_DATE environment variable and ids_gug_085.html#ids_gug_085.