How do we get grafana to use this date format: dd/mm/yyyy hh: mm: ss (timestamp)

Grafana Time Series Panel
,
1

What i would like
I want to use this date format in grafana: 05/10/2021 13:10:10

when i import the csv file into grafana, the format date is change :
image

how i can fix this problem while using this format: dd/mm/yyyy hh:mm:ss

Thanks

2

You have not said what platform or version of Grafana you are using but assuming you are on v7.2 or above then you need to change the [date_formats] section of the Grafana config file. For Linux this is usually /etc/grafana/grafana.ini

For example some of the values you can set:

[date formats]
full_date = DD/MM/YYYY HH:mm:ss
interval_day = MM/DD
interval_hour = MM/DD HH:mm
interval_minute = HH:mm
interval_month = YYYY-MM
interval_second = HH:mm:ss
interval_year = YYYY

More info:

4 Likes
3

Thanks for the response.
But i still have the same problem. I’m using grafana 8.1.5 version. I’m using infinity and CSV datasources. I have this date format in my csv file:

image

When i put my file in grafana, the date format has change to : 10/05/2021 (MM/DD/YYYY) not (DD/MM/YYYY)
In grafana.ini, i made these modifications and it does not work:
image

I don’t know, if you have an idea.

Thanks

1 Like
4

Here is an extract of my ini file.
Maybe it helps someone.
I can only say it works perfectly

[date_formats]
# For information on what formatting patterns that are supported https://momentjs.com/docs/#/displa$

# Default system date format used in time range picker and other places where full time is displayed
full_date = DD-MM-YYYY HH:mm:ss

# Used by graph and other places where we only show small intervals
interval_second = HH:mm:ss
interval_minute = HH:mm
interval_hour = DD/MM HH:mm
interval_day = DD/MM
interval_month = MM-YYYY
interval_year = YYYY
4 Likes
5

service grafana-server restart works here