LocalizedDisplay

Specifies whether to display locale-sensitive data (such as dates) in the native format for the sqlf locale.

Syntax

LOCALIZEDDISPLAY { on | off }

Description

Specifies whether to display locale-sensitive data (such as dates) in the native format for the sqlf locale. The sqlf locale is the same as the Java system locale.

Note: NUMERIC and DECIMAL values are not localized when the J2ME/CDC/Foundation Profile is used, because of platform limitations.

Example

The following demonstrates LocalizedDisplay in an English locale:

sqlf(PEERCLIENT)> VALUES CURRENT_DATE;
1
----------
2011-05-16

1 row selected
sqlf(PEERCLIENT)> localizeddisplay on;
sqlf(PEERCLIENT)> VALUES CURRENT_DATE;
1
------------------
May 16, 2011

1 row selected