My Oracle Support Banner

Timezone, Date and Number Format Issue using ORDS (Doc ID 2486568.1)

Last updated on SEPTEMBER 15, 2022

Applies to:

Oracle REST Data Services - Version 18.3 and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
While migrating from OHS to ORDS, when running mod_plsql applications the numbers display with a comma (,) instead of a period (.) in the decimal separator and the dates are not correctly formatted.

Goal

Is there a way to set an equivalent to PlsqlNLSLanguage (i.e American_America.AL32UTF8) in ORDS to avoid the display incorrect formats or times?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.