Convert month name to number

  • What Grafana version and what operating system are you using?
    Grafana v9.5.2-cloud.1.f9fd074b

  • What are you trying to achieve?
    Convert Nginx time format (<daynumber>/<monthname>/<year>:<hour>:<minute><second> <offset from utc>) to Grafana’s default time format.

  • How are you trying to achieve it?
    Using the data transformations feature. I have tried an input format of DD\m\YY:HH:mm:SS and DD\M\YY:HH:mm:SS.

  • What happened?
    The month shows as January (01), or the output is blank.

  • What did you expect to happen?
    I expected the month to show as May (05) which is the month that shows in the raw logs.

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?

did you try “overwrite” ?