When assigning a variable name to date column in a MSSQL table the date format is changing from “yyyy/mm/dd” to an epoch format. I need to keep it in a “yyyy/mm/dd” format to allow end users to select a specific date from the pull-down list.
What Grafana version and what operating system are you using?
What are you trying to achieve?
Create a pull down list of report dates that an end user can select to show the respective graph for that date
How are you trying to achieve it?
Assign a variable name to the date column in a MSSQL table. The date format is yyyy/mm/dd in the table.
Variable query: select distinct(Report_Date) from visual
The preview/results shows up as an epoch time
What did you expect to happen?
Date format being “yyyy/mm/dd”
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?