1 2 3 4 5 6 7 8 9 10
| SELECT to_char(sysdate, 'DAY', 'nls_date_language=french' ) as "1_FR_JOUR",
to_char(sysdate, 'Day', 'nls_date_language=french' ) as "2_FR_Jour",
to_char(sysdate, 'day', 'nls_date_language=french' ) as "3_FR_jour",
to_char(sysdate, 'DAY', 'nls_date_language=english') as "1_UK_JOUR",
to_char(sysdate, 'Day', 'nls_date_language=english') as "2_UK_Jour",
to_char(sysdate, 'day', 'nls_date_language=english') as "3_UK_jour"
FROM dual;
1_FR_JOUR 2_FR_Jour 3_FR_jour 1_UK_JOUR 2_UK_Jour 3_UK_jour
MARDI Mardi mardi TUESDAY Tuesday tuesday |
Partager