Time series global language support

Time series data has limited support for non-default locales.

Datetime data

The DATETIME data type used in the TimeSeries subtype must be in the default U.S. format:
"yyyy-mo-dd hh:mm:ss:fffff"
yyyy
Year, expressed in digits
mo
Month of year, expressed in digits
dd
Day of month, expressed in digits
hh
Hour of day, expressed in digits
mm
Minute of hour, expressed in digits
ss
Seconds of minute, in digits
fffff
Fraction of a second, in digits

Character data

Character I/O is not GLS-compliant. You can convert time series data only to character strings that are in the default U.S. locale. You can use the BulkLoad function only on character data that is in the default U.S. locale.

However, the following character strings can use any locale and can contain multibyte characters:
  • Character fields in a TimeSeries data type
  • Column names
  • Table names
  • Calendar names
  • Calendar pattern names
  • Container names

Numeric data

Floating point data must use the default U.S. format:
  • The ASCII period ( . ) is the decimal separator.
  • The ASCII plus ( + ) and minus ( - ) signs must be used.

Decimal and money data types are GLS-compliant except that the ASCII plus ( + ) and minus ( - ) signs must be used.