Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT SYSDATE FROM DUAL;

SYSDATE

30-JAN-19

SELECT parameter, value from v$nls_parameters WHERE parameter IN ('NLS_TERRITORY', 'NLS_NUMERIC_CHARACTERS');

PARAMETER
VALUE

NLS_TERRITORY
AMERICA

NLS_NUMERIC_CHARACTERS
.,

SELECT TO_CHAR(sysdate, 'd') FROM DUAL;

TO_CHAR(SYSDATE,'D')

4

SELECT trunc(sysdate, 'IW') FROM DUAL;

TRUNC(SYSDATE,'IW')

28-JAN-19

SELECT 1 + trunc(sysdate) - trunc(sysdate, 'IW') FROM DUAL;

1+TRUNC(SYSDATE)-TRUNC(SYSDATE,'IW')

3

alter session set nls_territory ='FRANCE';
SELECT TO_CHAR(sysdate, 'd') FROM DUAL;

TO_CHAR(SYSDATE,'D')

3

SELECT parameter, value from v$nls_parameters WHERE parameter IN ('NLS_TERRITORY', 'NLS_NUMERIC_CHARACTERS');

PARAMETER
VALUE

NLS_TERRITORY
FRANCE

NLS_NUMERIC_CHARACTERS
,

SELECT trunc(sysdate, 'IW') FROM DUAL;

TRUNC(SYSDATE,'IW')

28/01/19