Formatting display of locale-sensitive data

To display dates, timestamps, numbers, and times in the format of the ij Session locale, use the LocalizedDisplay command.

Note: These options do not change the way Derby stores locale-sensitive data, simply the way the tool displays the data.

The following example demonstrates the use of LocalizedDisplay in an en_US locale:

ij> VALUES CURRENT_DATE;
1
----------
2011-05-23
1 row selected
ij> localizeddisplay on;
ij> VALUES CURRENT_DATE;
1
------------------
May 23, 2011
1 row selected