Oracle Year in full

Asked

Viewed 28 times

0

This question is allowed ?

Simple , in thesis

   SELECT TO_CHAR(SYSDATE, 'YEAR','NLS_DATE_LANGUAGE=PORTUGUESE') FROM DUAL;

You should return Two thousand and twenty-one. But returns TWENTY-TWENTY-ONE

Version 11 Nls of the session is English as those of the Bank

nls_language        AMERICAN    AMERICAN
nls_date_language   

What could be wrong ?

Source

1 answer

0

The documentation itself says that the return will always be in English.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.