Oracle 21c

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

CREATE TABLE PRÜFUNG (TERMIN DATE);
insert into PRÜFUNG values (to_date('01.19.2023','MM.DD.YYYY'));
1 rows affected

insert into PRÜFUNG values (to_date('03.19.2023','MM.DD.YYYY'));
1 rows affected

insert into PRÜFUNG values (to_date('06.19.2023','MM.DD.YYYY'));
1 rows affected

insert into PRÜFUNG values (to_date('07.19.2023','MM.DD.YYYY'));
1 rows affected

insert into PRÜFUNG values (to_date('10.19.2023','MM.DD.YYYY'));
1 rows affected

insert into PRÜFUNG values (to_date('12.19.2023','MM.DD.YYYY'));
1 rows affected

SELECT
CASE WHEN EXTRACT(MONTH FROM TERMIN) <= 6
THEN 'S' || EXTRACT(YEAR FROM TERMIN)
ELSE 'W' || EXTRACT(YEAR FROM TERMIN) END AS new_test
FROM PRÜFUNG;


NEW_TEST


S2023

S2023

S2023

W2023

W2023

W2023