Change date format from MySQL TIMESTAMP format

[Richard238]

• Which Grafana version and what operating system are you using?

9.2.3 on Win11 home

• What are you trying to achieve?
  UK styled date format from sql TIMESTAMP

• How are you trying to achieve it?

From mysql, date and time stored in TIMESTAMP format

SELECT Temp AS 'G/H Temp Now', Added AS 'Time:' 
FROM green_house.temperature 
ORDER BY Added desc LIMIT 1

• What happened?
  Results formatted as: YYYY-MM-DD HH:MM:SS

• What I would like to happen, would be to have it formatted as 16:23 25 Dec
  Or something similar, essentially drop the YYYY and SS and have month as three alpha.
  Month as numeric MM would be acceptable if alpha not possible.

Thank you.

[yosiasz]

Your question is really about mysql date function than grafana

Have you looked at the docu for mysql

MySQL DATE_FORMAT() Function

[Richard238]

Ok, yes done that. How do I get Grafana to keep it all on one line?