the idea is to be able to obtain the number of the week in a function in ORACLE but that it always returns the same values regardless of the language configuration so as not to give wrong calculations in the dates,
for example Spanish:
L M M J V S D
1 2 3 4 5 6 7
English:
D L M M j V S
1 2 3 4 5 6 7
The function I have for this is:
to_number(to_char(parametro_fecha,'D'))
The function to validate this always in the same language is validated with the language configuration in the TO_CHAR
ENGLISH is placed if you want Sunday to be equal to 1
either
ENGLISH if you want Monday to be equal to 1