Data format in sql query

in sql table format of data is like it 1643670000 - it mean 01.02.2022 , how can I set sql query to have normal data like eg. 02.02.2022
‌
MariaDB [piler]> select sent from metadata where from='toooo@domain.org' and sent>=1643670000;

MariaDB [piler]> select sent from metadata where `from`='toooo@domain.org' and sent>=1643670000;
+------------+
| sent       |
+------------+
| 1643703617 |
| 1643704067 |
....
MariaDB [piler]> describe metadata;
+-------------+---------------------+------+-----+---------+----------------+
| Field       | Type                | Null | Key | Default | Extra          |
+-------------+---------------------+------+-----+---------+----------------+
| id          | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| from        | varchar(255)        | NO   | MUL | NULL    |                |
| fromdomain  | varchar(255)        | NO   | MUL | NULL    |                |
| subject     | blob                | YES  |     | NULL    |                |
| spam        | tinyint(1)          | YES  |     | 0       |                |
| arrived     | int(10) unsigned    | NO   | MUL | NULL    |                |
| sent        | int(10) unsigned    | NO   | MUL | NULL    |                |
| retained    | int(10) unsigned    | NO   | MUL | NULL    |                |
| deleted     | tinyint(1)          | YES  | MUL | 0       |                |
| size        | int(11)             | YES  |     | 0       |                |
| hlen        | int(11)             | YES  |     | 0       |                |
| direction   | int(11)             | YES  |     | 0       |                |
| attachments | int(11)             | YES  |     | 0       |                |
| piler_id    | char(36)            | NO   | MUL | NULL    |                |
| message_id  | varchar(255)        | NO   | MUL | NULL    |                |
| reference   | char(64)            | NO   | MUL | NULL    |                |
| digest      | char(64)            | NO   |     | NULL    |                |
| bodydigest  | char(64)            | NO   | MUL | NULL    |                |
| vcode       | char(64)            | YES  |     | NULL    |                |
+-------------+---------------------+------+-----+---------+----------------+
19 rows in set (0.03 sec)
‌
Comments (3)
