Change date format from MySQL TIMESTAMP format

  • 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.

Your question is really about mysql date function than grafana

Have you looked at the docu for mysql

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