By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE billinginterval (id, von) AS
SELECT 1, DATE '2018-09-01' FROM DUAL;
1 rows affected
INSERT INTO billinginterval (id, von)
VALUES (3, TO_DATE('03.01.1919', 'DD.MM.YYYY'))
1 rows affected
INSERT INTO billinginterval (id, von)
VALUES (3, TO_DATE('03.01.19', 'DD.MM.YYYY'))
1 rows affected
ALTER SESSION SET NLS_TERRITORY = 'Germany';
select b.*,
TO_CHAR(von, 'YYYY-MM-DD') AS formatted_von
from billinginterval b
order by von desc;
| ID | VON | FORMATTED_VON |
|---|---|---|
| 1 | 01.09.18 | 2018-09-01 |
| 3 | 03.01.19 | 1919-01-03 |
| 3 | 03.01.19 | 0019-01-03 |