DBDATE extensions (deprecated)

When you set DBDATE to one of the era-based formats, the functions use era-based dates to convert between date strings and internal DATE values.

The DATE-format functions that support the extended era-based date syntax for the DBDATE environment variable are as follows:
  • rdatestr()
  • rstrdate()
The following example shows a call to the rdatestr() library function:
char str[100];
long jdate;
...
rdatestr(jdate, str);
printf("%s\n", str);
If you set DBDATE to GY2MD/ and CLIENT_LOCALE to the Japanese SJIS locale (ja_jp.sjis), the preceding code prints this value for the date 08/18/1990:
H02/08/18
Important: HCL OneDB™ products treat any undefined characters in the alphabetic era specification as an error.

If you set DBDATE to an era-based date format (which is specific to a Chinese or Japanese locale), make sure to set the CLIENT_LOCALE environment variable to a locale that supports era-based dates.