Oracle 21c

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

CREATE TABLE tbl (inc_date_time) AS
SELECT SYSDATE + LEVEL - 1
FROM   DUAL
CONNECT BY LEVEL <= 20;
20 rows affected

SELECT To_Char(t.inc_date_time,'yyyy-mm-dd hh24:mi:ss') AS Date_Time,
       To_Char(t.inc_date_time,'DD/MM/YYYY') AS dt
FROM tbl t
FETCH first 10 rows only


DATE_TIME
DT


2022-02-04 22:01:29
04/02/2022

2022-02-05 22:01:29
05/02/2022

2022-02-06 22:01:29
06/02/2022

2022-02-07 22:01:29
07/02/2022

2022-02-08 22:01:29
08/02/2022

2022-02-09 22:01:29
09/02/2022

2022-02-10 22:01:29
10/02/2022

2022-02-11 22:01:29
11/02/2022

2022-02-12 22:01:29
12/02/2022

2022-02-13 22:01:29
13/02/2022


SELECT To_Char(t.inc_date_time,'yyyy-mm-dd hh24:mi:ss') AS Date_Time,
       To_Char(t.inc_date_time,'DD/MM/YYYY') AS "DATE"
FROM tbl t
FETCH first 10 rows only


DATE_TIME
DATE


2022-02-04 22:01:29
04/02/2022

2022-02-05 22:01:29
05/02/2022

2022-02-06 22:01:29
06/02/2022

2022-02-07 22:01:29
07/02/2022

2022-02-08 22:01:29
08/02/2022

2022-02-09 22:01:29
09/02/2022

2022-02-10 22:01:29
10/02/2022

2022-02-11 22:01:29
11/02/2022

2022-02-12 22:01:29
12/02/2022

2022-02-13 22:01:29
13/02/2022

DATE_TIME	DT
2022-02-04 22:01:29	04/02/2022
2022-02-05 22:01:29	05/02/2022
2022-02-06 22:01:29	06/02/2022
2022-02-07 22:01:29	07/02/2022
2022-02-08 22:01:29	08/02/2022
2022-02-09 22:01:29	09/02/2022
2022-02-10 22:01:29	10/02/2022
2022-02-11 22:01:29	11/02/2022
2022-02-12 22:01:29	12/02/2022
2022-02-13 22:01:29	13/02/2022