SQLite 3.27

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

CREATE TABLE Appointments (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    fromDateTime TIMESTAMP NOT NULL,
    toDateTime TIMESTAMP NOT NULL,
    name VARCHAR(30) NOT NULL,
    description VARCHAR(200),
    type VARCHAR(50)
);
✓
Insert INTO Appointments ( fromDateTime, toDateTime, name, description ) VALUES
('2020-03-21 15:00:00', '2020-03-21 16:00:00', 'Test', 'Test Description'), 
('2020-03-22 15:00:00', '2020-03-22 16:00:00', 'Test 2', 'Test 2 Description'),    
('2020-03-22 16:00:00', '2020-03-22 17:00:00', 'Test 2', 'Test 2 Description'),    
('2020-03-22 17:00:00', '2020-03-22 18:00:00', 'Test 2', 'Test 2 Description'),           
('2020-03-21 00:00:00', '2020-03-25 23:59:59', 'Test', 'Test Description'),      
('2020-03-27 08:00:00', '2020-03-21 12:00:00', 'Test', 'Test Description'),
('2020-03-02 08:00:00', '2020-03-10 12:00:00', 'Joelle', 'Test Joelle');
✓
SELECT strftime('%d - %m - %Y', fromDateTime) AS y,
       strftime('%Y-%m-%d', fromDateTime) AS x
FROM Appointments


y
x


21 - 03 - 2020
2020-03-21

22 - 03 - 2020
2020-03-22

22 - 03 - 2020
2020-03-22

22 - 03 - 2020
2020-03-22

21 - 03 - 2020
2020-03-21

27 - 03 - 2020
2020-03-27

02 - 03 - 2020
2020-03-02

y	x
21 - 03 - 2020	2020-03-21
22 - 03 - 2020	2020-03-22
22 - 03 - 2020	2020-03-22
22 - 03 - 2020	2020-03-22
21 - 03 - 2020	2020-03-21
27 - 03 - 2020	2020-03-27
02 - 03 - 2020	2020-03-02