TIME without minute and seconds

Good morning is there anyway to arrange the time with out minutes and seconds?

I just need the date and hour. thank you very much

The entries in that column must be defined as DATETIME. As I do not know the names you used:

• "tabelle" the table you are using
• "dz" is the column name you are using

SELECT DATE_FORMAT(dz, "%Y %m %e - %h") FROM tabelle;

Converts: "2023-11-09 03:12:25" => "2023-11-09 - 03" "2024-01-10 12:31:00" => "2024-01-10 - 12"

thank you. i will try this.

yes this is set as DATETIME