Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE faculty ( firstname, lastname, birth_date ) AS
SELECT 'Alice',     'Adams',   DATE '2019-01-01' FROM DUAL UNION ALL
SELECT 'Betty',     'Burns',   DATE '2019-01-02' FROM DUAL UNION ALL
SELECT 'Carol',     'Charles', DATE '2019-01-03' FROM DUAL UNION ALL
SELECT 'Denise',    'Daniels', DATE '2019-01-04' FROM DUAL UNION ALL
SELECT 'Erin',      'Edwards', DATE '2019-01-05' FROM DUAL UNION ALL
SELECT 'Frances',   'Firth',   DATE '2019-01-06' FROM DUAL UNION ALL
SELECT 'Gabriella', 'Gambon',  DATE '2019-01-07' FROM DUAL;
7 rows affected

select firstname, lastname, birth_date
from   /*project.*/faculty
where  TO_CHAR( birth_date, 'DAY' ) = 'SUNDAY   ';


FIRSTNAME
LASTNAME
BIRTH_DATE


Frances
Firth
06-JAN-19


select firstname, lastname, birth_date
from   /*project.*/faculty
where  TO_CHAR( birth_date, 'fmDAY' ) = 'SUNDAY';


FIRSTNAME
LASTNAME
BIRTH_DATE


Frances
Firth
06-JAN-19


select firstname, lastname, birth_date
from   /*project.*/faculty
where  TO_CHAR( birth_date, 'DY' ) = 'SUN';


FIRSTNAME
LASTNAME
BIRTH_DATE


Frances
Firth
06-JAN-19


ALTER SESSION SET NLS_DATE_LANGUAGE = 'FRENCH';
select firstname, lastname, birth_date
from   /*project.*/faculty
where  TO_CHAR( birth_date, 'DY' ) = 'SUN';
select firstname, lastname, birth_date
from   /*project.*/faculty
where  TO_CHAR( birth_date, 'DY', 'NLS_DATE_LANGUAGE=ENGLISH' ) = 'SUN';


FIRSTNAME
LASTNAME
BIRTH_DATE


Frances
Firth
06-JANV.-19


select firstname, lastname, birth_date
from   /*project.*/faculty
where  TRUNC( birth_date ) - TRUNC( birth_date, 'IW' ) = 6;


FIRSTNAME
LASTNAME
BIRTH_DATE


Frances
Firth
06-JANV.-19